topic Re: Set analysyis in QlikView

Set analysyis

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

My set analysis is not working.

Is my set analysis is right?

Logic: = Sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={"$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))"}>}[# Open])

Thanks..

Re: Set analysyis

sunny_talwar — Mon, 23 Jul 2018 11:43:11 GMT

What exactly are you trying to accomplish here?

[Calendar Date]={"$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))"}

Re: Set analysyis

YoussefBelloum — Mon, 23 Jul 2018 11:46:38 GMT

Hi,

you should evaluate this date part:

$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))

using Date#() and the format you used inside your expression.

Re: Set analysyis

nareshthavidishetty — Tue, 24 Jul 2018 06:45:08 GMT

Hi,

We need to show the data roll back to 12 months in bar chart using set analysis.

Thanks,

Re: Set analysyis

jyothish8807 — Tue, 24 Jul 2018 07:07:37 GMT

For rolling 12 months, you try like this:

Dimension: [Calendar Date]

sum(Aggr(rangesum(above(total sum({<[Month Abbr]=, Year=, [Quarter Name]=>}[# Open]),0,12),[Calendar Date]))

Br,

Re: Set analysyis

Anonymous — Tue, 24 Jul 2018 08:18:21 GMT

There are a few examples for rolling periods, maybe they can help you.

Set Analysis for Rolling Periods

Re: Set analysyis

sunny_talwar — Tue, 24 Jul 2018 11:09:36 GMT

Roll back 12 months from today?

=Sum({$<[Month Abbr], Year, [Quarter Name], [Calendar Date] = {"$(='>=' & Date(AddYears(Today(), -1), 'DateFieldFormatHere') & '<=' & Date(Today(), 'DateFieldFormatHere'))"}>}[# Open])