how to write a drill down group

kunkumnaveen — Wed, 23 Nov 2016 07:19:57 GMT

Hello Everyone, this is my qliksense requirement,the thing is i had created a drill down group with two dimensions(Region,States) and named it as Product.

then i took a bar chart and added Product as Dimension and sum(sales) as a measure ...which is working great ,i mean drill down

now in a different chart i need to show the same group dimension but this time the dimension as to trigger only when the condition is true.

i mean in Add Dimension box i wrote this condition ....

if($(var_RHS)=1,Product,NULL())........

which is not working...can any suggestion on how to write a proper condition to trigger a group dimension in Qliksense

thanks

Re: how to write a drill down group

kunkumnaveen — Wed, 07 Dec 2016 06:35:09 GMT

Still looking for any suggestion on this....

Re: how to write a drill down group

shraddha_g — Wed, 07 Dec 2016 06:53:31 GMT

you can not use Drill down dimension in expression editor.

try:

if($(var_RHS) =1, Region,

if($(var_RHS) =1 and getselectedcount(Region)<>0,States,null()

))

topic Re: how to write a drill down group in App Development

how to write a drill down group

Re: how to write a drill down group

Re: how to write a drill down group