topic Re: Pivot Table Problem with IF statement in QlikView

Pivot Table Problem with IF statement

qobo_qwaka — Wed, 25 Nov 2020 16:16:04 GMT

Good day everyone,

I have a pivot table with 3 dimensions (Group, Name, Status) and 1 expressions. The usual selections are group and name, but group is not always available. I am using an if statement : if(IsNull(Group), MaxString(JUDGEMENTS), MaxString({<Name=>}JUDGEMENTS)).

If here is no group then I want the the expression to return only information for the selected name, but if there is a group then i want to ignore the name selection and return information for all names in the group.

Individually these two formula give me what i want but for some reson they don't work in the if statement.

Your assistance will be highly appreciated.

Re: Pivot Table Problem with IF statement

pradosh_thakur — Mon, 18 Feb 2019 11:20:30 GMT

Where are you using the expression ?

Try the below may be

if(len(trim(Group))=0, MaxString(JUDGEMENTS), MaxString({<Name=>}JUDGEMENTS))

Re: Pivot Table Problem with IF statement

qobo_qwaka — Mon, 18 Feb 2019 11:33:31 GMT

Hi Pradosh,

It doesn't work. I returns only the selected name even though the ignored by the if statement.

However what confuses me id that if i say the following it returns correct results.

if(len(trim(Group))=0, 'Yes', 'No')

Re: Pivot Table Problem with IF statement

pradosh_thakur — Mon, 18 Feb 2019 12:30:56 GMT

If you are using it in a dimension it may not work. in expression it should.

P.S. : I am sorry if i missed out on the reply as i am not getting notification of your replies. Please tag some other member who can help.