how to write a drill down group

[kunkumnaveen]

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

[kunkumnaveen]

HI

Still looking for any suggestion on this....

[shraddha_g]

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()

))