Let's talk tech Power to the user - dynamic color change You can dynamically change color of the application. The final outcome is presented below: Below is quick guide how to do that: In Script: 1) Create variables that you going to use as colors: SET vco_1='RGB(255,0,0)'; SET vco_2='RGB(179,0,0)'; SET vco_3='RGB(255,128,0)'; SET vco_4='RGB(179,89,0)'; SET vco_5='RGB(0,0,0)'; 2) Create inline table that will be used a list box: //OptionsListbox Option: load * inline [ Option Option1 Option2 Option3 Option4 Option5 ]; 3) Another table will be used as colors Matrix: ColorsMatrix: load * Inline [ Option1,Option2,Option3,Option4,Option5 '$(vco_1)','$(vco_2)','$(vco_3)','$(vco_4)','$(vco_5)', '$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)','$(vco_3)', '$(vco_2)','$(vco_1)','$(vco_5)','$(vco_3)','$(vco_4)', '$(vco_4)','$(vco_3)','$(vco_2)','$(vco_5)','$(vco_1)', '$(vco_3)','$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)', ]; *The number of colors is defined by numbers of variables: For 3 variables the matrix will be 3x3. In Front End 1) Create 5 variables that will used as a picker from listbox of “Options” vco_Opt1 =$(=fieldvalue($(v_Option),1)) vco_Opt2 =$(=fieldvalue($(v_Option),2)) vco_Opt3 =$(=fieldvalue($(v_Option),3)) vco_Opt4 =$(=fieldvalue($(v_Option),4)) vco_Opt5 =$(=fieldvalue($(v_Option),5)) and another variable that will be used as a lookup to the orphan (Option) table: =Chr(39)&Option&Chr(39) 2) Create an “Option” listbox Each time you create an object and you want to use one of the colors option
you need to add one of the color variables to the Calculated field window:
0 Comments
OverviewAge How to become a Nobel Prize Laureat Monetary value
In most cases when building Inline table, coma(,) is used as a default delimiter.
But, what if you you came across a file that have different delimiters and you need only few rows from that table? Good news is that there is no need to manually change every instance of that delimiter, instead you can use the 'delimiter is' statement at the end of the inline table to achieve required result. Example below is using '#' (hash) but in fact any ASCII sign can be assign for that purpose. INLINE: Load * Inline [ CATEGORY#VALUE SANA#1000 MANA#2000 PAKA#3000 ] (delimiter is '#') ; After reading Len O'Toole article A Tableau Dashboard Rebuilt in MicroStrategy, |
halloween.qvw | |
File Size: | 474 kb |
File Type: | qvw |