Solved: how to display date values from date to current da... - Qlik Community

vinod2086 · ‎2015-09-30

Hi friends,

in my straight table am using created_date column. in that created date contains 2012,13,14 & 15 data available but user want only 01/04/15 to till date. can you please share me the expression.

Thanks in advance.

MK_QSL · ‎2015-09-30

If(created_date >= Date#('01/04/15','DD/MM/YY'), created_date)

or

Aggr(If(created_date >= Date#('01/04/15','DD/MM/YY'), created_date),created_date)

Tick suppress when value is null in dimension tab

View solution in original post

MK_QSL · ‎2015-09-30

If(created_date >= Date#('01/04/15','DD/MM/YY'), created_date)

or

Aggr(If(created_date >= Date#('01/04/15','DD/MM/YY'), created_date),created_date)

Tick suppress when value is null in dimension tab

PrashantSangle · ‎2015-09-30

Hi,

Use makedate()

Syntax:

MakeDate(Year,Month,Date)

or

you can use master Calender Concept

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

vinod2086 · ‎2015-09-30

Thanks Manish

how to display date values from date to current date.