Set analysis and if condition

Mon, 05 Mar 2012 19:32:57 GMT

Hi,

I'm working on a pivot table that requires the user to select a single month first and then will display amounts in different categories for this month. So far this works.

Now I'm trying to display the development in a category in a mini chart within the table, with the month (MonthID) as dimension.

Using set analysis I can "break out" of the month selection the user made successfully, ie

sum({<MonthID=>}Amount)

This works fine too.

Now what I'm trying to accomplish is that this mini chart is only displayed when the amount *for the month the user has selected* is negative.

So the mini chart should display the amount development over time, including potentially positive amounts in months different to the one that the user has selected (but only if the amount in the month the user has selected is negative).

I tried this, but this leads to nothing, it seems the whole set analysis is not working using this formula because this will only show data for the month the user has selected

=if(sum(Amount)<0,sum({<MonthID=>}Amount))

Why is this happening and what can I do about it?

Thanks a lot for any help about this!

Set analysis and if condition

CELAMBARASAN — Tue, 06 Mar 2012 04:47:20 GMT

Hi,

Try including set analysis in the condition also.

=if(sum({<MonthID=>}Amount)<0,sum({<MonthID=>}Amount))

Hope it helps

Celambarasan

Set analysis and if condition

perumal_41 — Tue, 06 Mar 2012 04:55:11 GMT

Try this method .is useful for u

=sum({<MonthID=,DateFeild={'sum(Amount)<0'}>}Amount)

Regards

Perumal A

Set analysis and if condition

jagan — Tue, 06 Mar 2012 05:10:03 GMT

Hi,

Try this expression

=If(Sum({<MonthID=>}Amount) < 0, Sum({<MonthID=>}Amount), 0)

Hope this helps you.

Regards,

Jagan.

topic Set analysis and if condition in QlikView

Set analysis and if condition

Set analysis and if condition

Set analysis and if condition

Set analysis and if condition