Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshmdane
Partner - Contributor III
Partner - Contributor III

Set Analysis data type equivalent

Hi All,

Does data type should be same in set analysis?

Example:

SUM({<oderdate={'<=201712'}>}Sales)

oderdate is in text format and 201712 is in date format.

The above one is not working.Kindly help

Thanks & Regadrs,

Dinesh M

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Yes it should be same.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
OmarBenSalem

Try to put it btwn doubles quotes as a first test.

sunny_talwar

orderdate is text format? If that is true this may not work... but are you sure it is text? may be it is a number?

pradosh_thakur
Master II
Master II

May be try this

SUM({<oderdate={"=(date#(oderdate,'YYYYMM')<=DATE#(201712,'YYYYMM'))'}>}Sales)

Learning never stops.
dineshmdane
Partner - Contributor III
Partner - Contributor III
Author

Hi Sunny,

Yes, orderdate is in text format.