topic Re: Using Variables in an If Statement in QlikView

Using Variables in an If Statement

Wed, 08 May 2013 10:32:08 GMT

I am trying to create a button that toggles between a selection in a field and then showing all!!

Field - APInv.PayGroup (Data - GP, Local Gov, NHS, Non-NHS, Ophthalmic, Petty Cash, UPR, Utility)

Button 1 - =if(vPayGroup = 1 , 'NHS', '') This is created in Actions > Select In Field > Search String

This button works fine and toggles between showing 'NHS' and showing all

Button 2 - I want this to toggle between showing all and then all except NHS

I am unsure how to use this in the search string!

Any help would be much appreciated.

thanks

Andrew

Gysbert_Wassenaar — Wed, 08 May 2013 11:08:26 GMT

Try:

=if(vPayGroup = 1 , '(' & concat({1<[APInv.PayGroup] -= {'NHS'}>} distinct [APInv.PayGroup] , '|' ) & ')' )

Wed, 08 May 2013 12:49:57 GMT

This a good start thank you.

Unfortunately this is missing out 'Local Gov' & 'Petty Cash'!! I have checked the data to make sure that there is data to be shown and there is!!

Any suggestions?

Andrew

Gysbert_Wassenaar — Wed, 08 May 2013 12:51:33 GMT

Try:

=if(vPayGroup = 1 , '(' & concat({1<[APInv.PayGroup] -= {'NHS'}>} distinct chr(34) & [APInv.PayGroup] & chr(34) , '|' ) & ')' )

Wed, 08 May 2013 13:26:00 GMT

That's great, it's now working fine.

Thanks gysbert, mucha appreciated.

Andrew