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: 
tim_at_ford
Contributor III
Contributor III

Set Analysis Syntax to Switch KPI

I have a new requirement from my Business Analyst and I hope someone has encountered this along the line and help with the Set Analysis Syntax.

 

Currently, I have a KPI that is parsed by customer, each customer has a separate tab. 

 

Because the screens are identical we'd like to integrate both customers under one tab. 

 

My KPI, however, is just a sum on columns for customer 1 in the first tab and  customer 2 in the second tab.

 

Customer 1  Sales Totals to Tab 1

Customer 2  Sales Totals to Tab 2

 

If our user selects customer 2 what kind of set analysis would I have to have in order to switch between the two?

 

Customer 1 is the default then I want to switch and display customer 2 totals and back again.

Labels (1)
3 Replies
sunny_talwar

Why do you need set analysis for this? That seems more like a default behavior....

tim_at_ford
Contributor III
Contributor III
Author

Sony

Thank you for the reply!

What we are doing is totally up each line by customer, current year and previous year, and then subtracting each for difference.

Interesting you mentioned default!

Can you expand on that idea because this might be something simple I'm over looking!

Thanks for the help!

 

 

 

Brett_Bleess
Former Employee
Former Employee

I believe to what Sunny was referring is the fact when a user makes a selection, we calculate things based upon that selection, so that is was confusing, as you did not mention you wanted something to calculate outside the selections, which is when you would want to use Set Analysis.  The best I have for you is the following specific Design Blog post on Set Analysis, and then I will put the base URL for the Design Blog area below that in case you want to search the posts there further on your own, these are mostly how-to posts from our experts, so you should be able to get some useful ideas looking in that area.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

I think you will need to provide further clarification of the use case to get further responses from others.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.