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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sureshmaddipati
Contributor III
Contributor III
‎2024-04-03 11:42 AM

Set Analysis

I have 2023 year colum under which I need to derive value of 2024 year using set analysis.

I have used dimensionality  concept and used set analysis as mentioned below for example

match([year]=2023),

Num(sum{<year={2024}sales)

Labels (1)
Labels
426 Views
0 Likes
2 Replies
JonnyPoole
Former Employee
Former Employee
‎2024-04-03 11:53 AM

I don't understand the question. 

412 Views
0 Likes
sureshmaddipati
Contributor III
Contributor III
‎2024-04-03 11:56 AM
Author

In response to JonnyPoole

I have year dimension as columns 2023 ,2024,2025,2026 and 2027 as columns

I need 2024 measure value under 2023 columns using set analysis. 

410 Views
0 Likes