Discussion Board for collaboration related to QlikView App Development.
I have a formula as follows
J,M,N are a column in database i want M or N in place of J .
Basically i want to change metrics on selection in list box where list box will be having J,M,N
Can any one help me?
View solution in original post
I don't understand fully your requirement, you can acheive by using some excel file as below,
->Create a excel file with two filed , one will have J,M,N and other will have expression.
->Load into QV
->Create a variable and point to the expression field in the excel.
->Create a list box and point to dimension field
Or else explain ur question with small example would be helpful
Please find the attached sample. Hope this helps.
Same thing i want
But i also want those column names in standard deviation and average field as well.
Also can you tell me how to format 23.4567<=x<45.6789 to 23.4<=x<45.6?