topic Re: Set Analysis Syntax in QlikView

Set Analysis Syntax

ziadm — Wed, 10 Aug 2016 22:22:31 GMT

I have a Calendar that looks like this

CALENDAR_DATE	WEEK_NUMBER	PrYrWeek
5/2/2016	201614	201514
5/3/2016	201614	201514
5/4/2016	201614	201514
5/5/2016	201614	201514
5/6/2016	201614	201514
5/7/2016	201614	201514
5/8/2016	201614	201514

WEEK_NUMBER is the Week the date and PrYrWeek is the week number aligned from the last Year,

I have a chart the Dimension by WEEK_NUMBER and Sum(Sales) strgiht forward (NP)

I need to add another expression to the chart to Sum(Sales of PrYrWeek)

like this

Sum({ $<WEEK_NUMBER = {"=$(" & PrYrWeek & ")" } >} Sales)) . This does not work .. Any idea

Re: Set Analysis Syntax

sunny_talwar — Wed, 10 Aug 2016 22:29:11 GMT

Try this approach instead:

The As-Of Table

Re: Set Analysis Syntax

swuehl — Wed, 10 Aug 2016 22:32:18 GMT

I think you should apply something like an AsOf table

The As-Of Table

or a canonical date

Canonical Date

You basically need to create a link table with a field you can use as dimension in your chart, where each field value links to a calendar date field value from current and previous year (multiple records per dimensional value).