Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>
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.
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>
I don't have Qlik Sense near, but in Qlik Cloud it works the same way I posted.
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>
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>