Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
cbaqir
Valued Contributor

If Statement with Drill Down Group

How do I make my group (dVPSUPROGAU) work with this as a dimension?

=if(AU_NUM='848020',null(), dVPSUPROGAU)

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: If Statement with Drill Down Group

Is AU_num one of the fields in the drill down group?

Then add this as a calculated dimension when creating the group

If ( au_num  = your number, null (), au_num ())

If this is not a part of the drill down group then add the conditional in the enable condition of the dimension

View solution in original post

2 Replies
vinieme12
Esteemed Contributor II

Re: If Statement with Drill Down Group

Is AU_num one of the fields in the drill down group?

Then add this as a calculated dimension when creating the group

If ( au_num  = your number, null (), au_num ())

If this is not a part of the drill down group then add the conditional in the enable condition of the dimension

View solution in original post

cbaqir
Valued Contributor

Re: If Statement with Drill Down Group

I have a similar situation that I'm hoping you can advise on.

I have a drill down group with CTGY_CODE and ACCT. I need to NULL data for 848020 but I still want the drill down to work. Per your instructions, I am using =if(AU_NUM='848020',null(),CTGY_CODE) for CTGY_CODE and =if(AU_NUM='848020',null(),ACCT) for ACCT. and this hides the data when 848020 is selected but it no longer drills down to the ACCT level.

If I change the expression from =if(AU_NUM='848020',null(),CTGY_CODE) to CTGY_CODE, the drill down to ACCT works but it doesn't obscure 848020 data.