topic Re: If function in QlikView

If function

iliaisyah — Tue, 19 Feb 2019 04:30:01 GMT

i wish to add calculated dimension in pivot table to show only system called 'MPC' and MAIC

here is my calculated dimension

=if([system] = 'MPC' or [system]='MAIC',[system])

but error in expression

if i want to display only MPC

=if([system] = 'MPC',[system])

it works but the table shows MPC and -

how i want to make the table only MPC and MTG only

here is the excel. apology as i cannot open anymore qvw file as im using free edition

Re: If function

MindaugasBacius — Tue, 19 Feb 2019 05:39:27 GMT

You need to change expression instead of adding calculated dimensions.
Use set analysis to achieve your goal like:
Count({<system = {'MPC', 'MAIC'}>} Field)

Re: If function

iliaisyah — Tue, 19 Feb 2019 06:30:01 GMT

the equation is still error in expression

Re: If function

iliaisyah — Tue, 19 Feb 2019 06:38:57 GMT

plus, the expression will have 12 expression as the value is from Jan to Dec (01-12)

Re: If function

sunny_talwar — Tue, 19 Feb 2019 13:19:58 GMT

I don't see why this would error out

=If([system] = 'MPC' or [system] = 'MAIC', [system])

But may be try this as an alternative

If(Match(system, 'MPC', 'MAIC'), system)