topic Ignore selections in QlikView

Ignore selections

Wed, 22 Feb 2012 15:55:25 GMT

Hi All,

I came across an expression on the Forums which I have used to ignore certain selections:

sum({<[Year&Month]=>} [LCY Balance]) ---> Which to me says: ignore the Year&Month selection/s and sum the LCY balances.

However, I don't know how to add an IF argument to this expression, so that I can say: ignore the Year&Month selection and return the LCY balance where the currency is only EUR (for example).

Any ideas?

Re: Ignore selections

Wed, 22 Feb 2012 15:57:14 GMT

I should probably mention that using a List box isn't enough - I want to be able to show a select group of different currencies in the same Straight Table, whilst keeping all currencies in a "Total" column.

Ignore selections

Wed, 22 Feb 2012 16:36:57 GMT

Have you tried with an if?

if(currency = 'EUR', sum({<[Year&Month]=>} [LCY Balance]), sum([LCY Balance]) )

Ignore selections

Thu, 23 Feb 2012 14:28:22 GMT

Thanks for the advice Federico - it made sense that it should be quite simple to amend, but I needed to re-arrange your suggestion slightly so that it looked like this:

SUM({<[Year&Month]>}

IF([LCY]='EUR', [LCY Balance]))

All in all, I just needed to place the "ignore" function between the SUM and the IF, and now it works perfectly.

Thanks for the suggestion!

Ignore selections

jagan — Thu, 23 Feb 2012 15:09:05 GMT

Hi,

Check this expression

=SUM({<[Year&Month]=, [LCY]={'EUR'}>} [LCY Balance])

Regards,

Jagan.