Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Please find the attached sample. Hope this helps.
Hi tresesco,
Thanks
Same thing i want
But i also want those column names in standard deviation and average field as well.
Regards,
Gaurav
Also can you tell me how to format 23.4567<=x<45.6789 to 23.4<=x<45.6?
Try like:
=Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim))))
Try:
=Num(SubField(Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim)))),'<',1),'##.##')
& '<=X<'
& Num(SubField(Class($(vDim),$(=Stdev($(vDim))),'x',$(=Avg($(vDim)))),'<',-1),'##.##')