Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Date criteria in set analysis

Hi Experts,

How can I add a specific filter criteria (field name) in the following expression instead of hard values, I would like to get the value which is lesser than or equal to the selections.


The filter name is: DocDate

Sum({$<DocDate = {'<=08/30/2016'}>} Debit) - Sum({$<DocDate = {'<=8/30/2016'}>} Credit)

Kindly help!


3 Replies
MVP & Luminary
MVP & Luminary

Re: Date criteria in set analysis

Hi,

Try like this

For max date selected

Sum({$<DocDate = {'<=$(=Max(Date))'}>} Debit) - Sum({$<DocDate ={'<=$(=Max(Date))'}>} Credit)


OR for Today date


Sum({$<DocDate = {'<=$(=Today())'}>} Debit) - Sum({$<DocDate ={'<=$(=Today())'}>} Credit)


Regards,

Jagan.

Not applicable

Re: Date criteria in set analysis

Thanks Jagan.

MVP & Luminary
MVP & Luminary

Re: Date criteria in set analysis

Hi Shazad,

If you got the answer close this thread by giving Correct Answer, so that it would be helpful for others.

Regards,

jagan.