Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot analysis year week weekday

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 VeckodagFsg CY tkrLY
201553 - MÅ50194523 242
Labels (1)
1 Reply
sunny_talwar
MVP
MVP

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