Pivot analysis year week weekday

Fri, 29 Jan 2016 15:21:31 GMT

hi.

i am intrested in matching the exact year week weekday (-52 weeks).

see example below here i wish for the data to be pushed to 201553 in the LY column.

LY Set analysis

=sum({<[År Vecka Veckodag] ={ ">= $(=Min([År Vecka Veckodag_LY]))<= $(=Max([År Vecka Veckodag_LY]))"},

//$(#vKnapp_jfr),

[ÅrSäsong] = ,
[År Vecka] = ,
År = ,
Månad = ,
[År Månad] = ,
Vecka = ,
Veckodag = ,
//[År Vecka Veckodag] =,
Datum =>}
Nettobelopp)

I have the following set analyis that steers that the LY column but wish for 201501-Må value to be represented in the LY column to match see below for how i wish the data to be presented.

	År Vecka Veckodag	Fsg CY tkr	LY
	201553 - MÅ	5019	4523 242

Re: Pivot analysis year week weekday

sunny_talwar — Fri, 29 Jan 2016 15:23:41 GMT

You need to use Above() function to do that. There has been alot of discussion on this kind of requirement. You can look at those or provide a sample data so that we can show you how it can be done

topic Re: Pivot analysis year week weekday in QlikView

Pivot analysis year week weekday

Re: Pivot analysis year week weekday