Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, i have the below expression in my qliksense dashboard which gets me highest sector based upon sales for the currentdate vs same day in prior week, however i need to expand this to add an IF condition to where vturnover is <=1000000, I have tried a few things but nothing is working.
Current Expression::
FirstSortedValue(Sector, +aggr(((Sum({<Date={"$(vMaxDate)"},Sector -={'Unknown Sector','Unknown','Undefined'},$(vOmitSelection_Date)>}$(vTurnover))
/
Sum({<Date={"$(=date(Max(Date)-7))"},Sector -={'Unknown Sector','Unknown','Undefined'},$(vOmitSelection_Date)>}$(vTurnover)))-1),Sector),1)
thanks for all the help!
When you say it is not working, what do you mean?
Is the expression giving unexpected results?
Is the expression failing completely and giving an error message?
Can you give an example of an attempt that includes the if statement?