Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
Below the expression used in both Qlikview and Qliksense. However, only Qlikview showing the value for column '30 days' , but not in Qliksense. Any idea?
sum( {<PAYMENT_STATUS={'Outstanding'},PAYMENT_OUTSTANDING_DAYS = {'<30'}>} SALES)
Try this
sum( {<PAYMENT_STATUS={'Outstanding'},PAYMENT_OUTSTANDING_DAYS = {"<30"}>} SALES)
Try this
sum( {<PAYMENT_STATUS={'Outstanding'},PAYMENT_OUTSTANDING_DAYS = {"<30"}>} SALES)
wow ..zhaofeng..is that simple . it works ..just wonder why it need to be in double quotes when comes to Qliksense. Thanks Bro !
Cuz your modifier contains calculation.
PAYMENT_OUTSTANDING_DAYS may have several different days,you want to find out the days that less than 30.So you add a calculation to this modifier.
In Qlik Sense, any modifier which contains calculation must use double quotes.