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: 
Channa
Specialist III
Specialist III

Pivot


I have two dimension by location and Store

reach and notreach are the measure

A1,A2,A3,A4 are my second dimension

i need to show below

please see the attach how can i achieve this

Channa
Labels (1)
2 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

see file attached

Channa
Specialist III
Specialist III
Author

can you share the script please

 

this is my sample data in both sheet1 and sheet2

 

reach and not reach need to show with respect to T1,T2.. but sale by location .. can you please check

 

 

Channa