topic Re: Set Analysis in QlikView

Set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis

sunny_talwar — Mon, 25 Apr 2016 15:42:31 GMT

Is this issue resolved Gopi?

Re: Set Analysis

Anonymous — Mon, 25 Apr 2016 15:49:57 GMT

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)

Re: Set Analysis

Tue, 26 Apr 2016 06:48:48 GMT

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???

Re: Set Analysis

Tue, 26 Apr 2016 06:49:33 GMT

Hi Sunny,

No not yet...

Re: Set Analysis

sunny_talwar — Tue, 26 Apr 2016 15:56:03 GMT

Try this May be:

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

Re: Set Analysis

Wed, 27 Apr 2016 05:59:54 GMT

Ooh Sunny,

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

Thanks...

Re: Set Analysis

sunny_talwar — Wed, 27 Apr 2016 15:23:31 GMT

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