Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshmdane
Partner
Partner

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
MVP & Luminary
MVP & Luminary

Hi,

Yes it should be same.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
OmarBenSalem
Partner
Partner

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
Partner
Author

Hi Sunny,

Yes, orderdate is in text format.