Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview users,
I created a straight table with a 'custom dimension' by the use of te Valuelist function.
See the example below:
The dimension definition is as follows:
=valuelist('TW1','TW2')
For the columns 'Alpha' 'TKP' and 'Interpolated (-10)', i use expressions. The Alpha expression is as follows:
if(valuelist('TW1','TW2')='TW1','#',' ')
&
if(valuelist('TW1','TW2')='TW2','#',' ')
I have a list selectionbox with a list of TW's (Time Windows)
See example below:
How can I make sure that the "TW1"-row in my straight table is only shown when "TW1" is selected in the selectionbox?
Also, the list selectionbox allows multiple selections.
Use variables...
Create two variables
Variable1 and Variable2 .
Variable1= subfield(concat(Time_selection,'|'),'|',1)
Variable2= subfield(concat(Time_selection,'|'),'|',2)
Use dimension as valulist(Variable1,Variable2)
Please share your application....
Use variables...
Create two variables
Variable1 and Variable2 .
Variable1= subfield(concat(Time_selection,'|'),'|',1)
Variable2= subfield(concat(Time_selection,'|'),'|',2)
Use dimension as valulist(Variable1,Variable2)
Please share your application....
Hi,
I added my application as an attachment