Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?


Hi All


I use below expression at dimension :-


=IF(GROUP_CLASS='G1',company)


it does not work for my QVW.


Can some one share with me does Ver12 able to view the result ?


Paul Yeo

1 Solution

Accepted Solutions

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

Seems to work for me in QV12

Capture.PNG

Note the highlighted part... this shows up because you have not checked 'Suppress When Value Is Null' on the dimensions tab... once you do that... the null should go away and the total should adjust also

5 Replies
paulyeo11
Valued Contributor II

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

My QVW

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

Seems to work for me in QV12

Capture.PNG

Note the highlighted part... this shows up because you have not checked 'Suppress When Value Is Null' on the dimensions tab... once you do that... the null should go away and the total should adjust also

stabben23
Honored Contributor

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

Why not use set analysis in Your sum sales? Will save you a lot of memory while createing the Object.

Use Country Company as Dimension, in sum(sales) add, sum({<GROUP_CLASS={'G1'}>}sales)

paulyeo11
Valued Contributor II

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

Hi sunny

wow you are very able to zoom in very deep.

I though it is due to $SYN key issue , after clear all my $SYN key i still face the same issue , so i using just one sales table file , now finally you are able to point out the issue,

Thank you

Paul Yeo

paulyeo11
Valued Contributor II

Re: Does =IF(GROUP_CLASS='G1',company) able to work in ver 12 ?

Hi Staffan

I am aware that i can filter at expression. it is just that i want to know the reasons why it cannot work. As it is alway important understand why ?

Paul Yeo

Community Browser