topic How to do up/down image in QlikView

How to do up/down image

Tue, 14 Aug 2012 09:13:46 GMT

Hi,

How to do this, the basis is AMOUNT

if there's no MONTH selected - the comparison should be This Year vs. Last Year

if there's month is Selected, the comparison should be This Month vs. Last Month

if month is January, the comparison should be ThisYear January vs. LastYear December

If Current is GREATER --- arrow up (red)

If Previous is GREATER --- arrow down (green)

That is the color coding, because it is for EXPENSES

Please help. thanks. Give me sample if ever. Thanks.

manojkvrajan — Tue, 14 Aug 2012 19:25:44 GMT

if(getselectedcount(Month)<=0, <<This year Vs Last Year>>>,

if(getselectedcount(Month)>0, <<This month Vs Last month>>>,

if(Month = 'January', <<This year January Vs Last Year January>>>)))

I hope this helps.

shree909 — Tue, 14 Aug 2012 20:21:09 GMT

Hi,

just build the different charts with no month,month,month is january and in the the layout condition of the chart use

getselected count(month) <>0 ,>0 something like this.

so when ever a selection is made that respective chart is dispalyed and the other charts are hidden.