Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to do up/down image


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.

2 Replies
Contributor III

Re: How to do up/down image

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.

Valued Contributor II

Re: How to do up/down image


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.

Community Browser