Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
limfungkeat
Contributor III
Contributor III

Set Analysis - Same expression used, value shown in Qlikview but not in Qliksense

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)

 

Labels (3)
1 Solution

Accepted Solutions
zhaofeng
Partner - Creator
Partner - Creator

Try this

sum( {<PAYMENT_STATUS={'Outstanding'},PAYMENT_OUTSTANDING_DAYS = {"<30"}>} SALES)

View solution in original post

3 Replies
zhaofeng
Partner - Creator
Partner - Creator

Try this

sum( {<PAYMENT_STATUS={'Outstanding'},PAYMENT_OUTSTANDING_DAYS = {"<30"}>} SALES)

limfungkeat
Contributor III
Contributor III
Author

wow ..zhaofeng..is that simple . it works ..just wonder why it need to be in double quotes when comes to Qliksense. Thanks Bro ! 

zhaofeng
Partner - Creator
Partner - Creator

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.