topic Re: Why this expression not work =IF(GROUP_CLASS="G3",COMPANY) in QlikView

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

paulyeo11 — Fri, 02 Mar 2018 10:52:00 GMT

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

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

Chanty4u — Fri, 02 Mar 2018 10:57:17 GMT

try this

=if(match(GROUP_CLASS,'G3'),GROUPCLASS)

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

Miguel_Angel_Baeyens — Fri, 02 Mar 2018 11:00:23 GMT

If both fields exist in the data model and G3 is a value in the field GROUP_CLASS, then use single quotes instead of doubles in the If() comparison.

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

paulyeo11 — Fri, 02 Mar 2018 11:07:29 GMT

Hi Miguel

I have try :-

=IF(GROUP_CLASS='G3',COMPANY)

it still not display any thing,

Paul Yeo

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

paulyeo11 — Fri, 02 Mar 2018 11:09:52 GMT

Hi Chanty

I try below , i get invalid expression :-

=IF(match(GROUP_CLASS,'G3',COMPANY)

Paul

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

Chanty4u — Fri, 02 Mar 2018 11:12:50 GMT

try this

=if(match(GROUP_CLASS,'G3'),Company)

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

paulyeo11 — Fri, 02 Mar 2018 11:27:49 GMT

Hi Chanty

it does not work , i does not filter G3 , and display all company. no error

Paul

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

Miguel_Angel_Baeyens — Fri, 02 Mar 2018 12:45:45 GMT

Can you share at least a screenshot where we can see two listboxes, one for GROUP_CLASS with G3 selected and another for COMPANY?

Are you sure there are values?

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

paulyeo11 — Fri, 02 Mar 2018 12:51:56 GMT

Hi Miguel

Enclosed my QVW

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

Miguel_Angel_Baeyens — Fri, 02 Mar 2018 13:13:02 GMT

It works for me, please review your expression.

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

paulyeo11 — Fri, 02 Mar 2018 13:23:28 GMT

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>

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

Miguel_Angel_Baeyens — Fri, 02 Mar 2018 15:43:41 GMT

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.

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

paulyeo11 — Fri, 02 Mar 2018 21:41:30 GMT

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>

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

Miguel_Angel_Baeyens — Sat, 03 Mar 2018 09:50:50 GMT

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

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

paulyeo11 — Sat, 03 Mar 2018 10:05:32 GMT

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>

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

paulyeo11 — Sun, 04 Mar 2018 02:53:35 GMT

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