Qliksense help

[arusanah]

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?

[sunny_talwar]

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

[arusanah]

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.

[sunny_talwar]

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