Why this expression not work =IF(GROUP_CLASS="G3",COMPANY)

[paulyeo11]

Hi All

I want to filter only display those customer handle by G3.

So instead of COMPANY field at dimension.

I replace with :-

=IF(GROUP_CLASS="G3",COMPANY)

But it got error , does not filter , and not display any company.

Paul

[paulyeo11]

Hi Miguel

It mean my QV ver does not support that expression , as I am still using V9

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Miguel_Angel_Baeyens]

It should, I don't recall that difference, it could also be a bug in the version.

Unfortunately, unless you extended your maintenance agreement, QV9 is out of support, so you will have to find an alternative (maybe in the script?) to create such field.

[paulyeo11]

I found the solution

I add condition at expression :-

Sum ( if ( GROUP_CLASS =‘G3’,sales))

It work fine too.

Funny I also try your suggestion at QS feb 2018 also cannot.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Miguel_Angel_Baeyens]

I don't have Qlik Sense near, but in Qlik Cloud it works the same way I posted.

[paulyeo11]

Look like it is due to my data model , since QS also cannot

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[paulyeo11]

Yes correct , I main issue is I cannot find my data model where go wrong ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>