Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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
1 Reply
sunny_talwar

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