topic Re: Qliksense help in QlikView

Qliksense help

arusanah — Wed, 08 Jun 2016 16:39:12 GMT

in qliksense , I have a requirement . I have a month field . if user selects lets say 'Feb' , expression should check data for month 'Jan' and display up or down arrow depending on value of measure should display image. in same " Simple KPI' object . how can I achieve it?

Re: Qliksense help

sunny_talwar — Wed, 08 Jun 2016 16:43:38 GMT

Would you be able to share some sample data? and the expected output?

Re: Qliksense help

arusanah — Wed, 08 Jun 2016 17:34:12 GMT

hi sunny T,

Monh	sales
jan	10
feb	20
march	30
april	21
may	33
jun	42
jul	56
aug	76

here the the sample data . what I need is if person selects apr-march Then it shud give sum(sale for apr-march) and compare sales for( jan-feb) and if sale > current selection it should display up arrow with current selection result . , if its less then down arrow and so on . how can we achieve it in qliksense.

Re: Qliksense help

sunny_talwar — Wed, 08 Jun 2016 17:39:01 GMT

May be like this:

If(Sum(Sales) >= Sum({<DateField = {"$(='>=' & Date(MonthStart(Max(DateField), -1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(Max(DateField), -1), 'DateFieldFormatHere'))"}, Month, Year, MonthYear, Quarter, Week, WeekYear, QuarterYear>}Sales), ArrowUp, ArrowDown)

I don't really know how to get the ArrowUp and ArrowDown image in QlikSense, but the if statement above should work for you