topic Re: Dynamic selection of variables in QlikView

Dynamic selection of variables

Thu, 14 Nov 2013 09:51:26 GMT

Hi All,

I have a formula as follows

=class(J,$(=Stdev(J)),'x',$(=Avg(J)))

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?

Regards,

Gaurav

qliksus — Thu, 14 Nov 2013 10:03:31 GMT

Hi,

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

Done.

Or else explain ur question with small example would be helpful

tresB — Thu, 14 Nov 2013 10:18:02 GMT

Please find the attached sample. Hope this helps.

Thu, 14 Nov 2013 10:33:17 GMT

Hi tresesco,

Thanks

Same thing i want

But i also want those column names in standard deviation and average field as well.

Regards,

Gaurav

Thu, 14 Nov 2013 10:48:58 GMT

Also can you tell me how to format 23.4567<=x<45.6789 to 23.4<=x<45.6?

tresB — Thu, 14 Nov 2013 10:51:12 GMT

Try like:

=Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim))))

tresB — Thu, 14 Nov 2013 11:01:42 GMT

Try:

=Num(SubField(Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim)))),'<',1),'##.##')

& '<=X<'

& Num(SubField(Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim)))),'<',-1),'##.##')