topic General If show condition in QlikView

General If show condition

Mon, 04 Jul 2011 09:45:42 GMT

Hello Experts,

I am trying to hide some charts based on the conditions as seen below:

if(LTVType.Description = 'LTV (BTL)'& if(Granularity = 'YTD'),1,0) --- If i use this show condition, it doesnt work

if(LTVType.Description = 'LTV (BTL)', if(Granularity = 'YTD',1,0)) --- If i use this show condition, it shows up whenever I click on YTD ignoring the LTV BTL...

I want to check it to check for both the show conditions... am i doing something wrong?? please suggest.

Thanks in advance

Re: General If show condition

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 09:59:22 GMT

Hi,

The conditional should be using AND instead, as in

if(LTVType.Description = 'LTV (BTL)' AND Granularity = 'YTD', 1, 0)

But what you say seems like everytime you select "YTD" in Granularity, "LTV (BTL)" is selected as well in the LTVType.Description field, maybe because both tables are associated? That explains that everytime you click "YTD" in Granularity the first part of the first If() is true. You may need to use GetFieldSelections() or Count() instead.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

General If show condition

kaushiknsolanki — Mon, 04 Jul 2011 09:59:24 GMT

Hi,

Use And keyword instead of &.

So your expression will be

if(LTVType.Description = 'LTV (BTL)' and Granularity = 'YTD',1,0)

Regards,

Kaushik Solanki

General If show condition

Mon, 04 Jul 2011 10:07:33 GMT

Hello Miguel,

Today I realised that there is a difference between using & - and for the conditions.... anyways thanks for the help it worked exactly.

Mady