Set Analysis

[#1]

Hi Guys,

How can i get all records for till date using set analysis? for ex today(25-Apr-2016) i wanna all records for the month using set analysis

[sunny_talwar]

Is this issue resolved Gopi?

[Anonymous]

Hi,

If the date is month wise , you can use this .. please let me know if your DATA is in datewise .....

LOAD * INLINE

[

date, sales

march, 5000

march, 6555

april, 555

april, 77

april, 8888

april, 1200

];

For  Expression :

sum({1<date={april}>}  sales)

[#4]

Hi Allu,

Thanks for concern about this issue, this one solved. But my interview asked me today date without any date mention. How do you do without knowing the exact date???

[#5]

Hi Sunny,

No not yet...

[sunny_talwar · Accepted solution]

Try this May be:

{<DateField = {"$(='<=' & Date(Today(), 'DateFieldFormatHere'))"}>}

[#7]

Ooh Sunny,

Thank you so much it works well.....

Thanks...

[sunny_talwar]

If my response proved helped you then please mark it as the correct answer. This way people in future will find it useful as well when they land on this thread

Qlik Community Tip: Marking Replies as Correct or Helpful