Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kaitlynwagner_s
Contributor II
Contributor II

New to Qlik- Understanding Static Visuals vs Dynamic

Hi all

I am an extremely new user to Qlik with minimal training. I have tried watching some video tutorials but i fear that my lack of knowledge henders my searching for the right answer, so I hope you can help!

All my charts are built, but where i am struggling is how to make One chart Static and the other dynamic. Here is my scenario:

Example: How many days does it take for our product (let's say Jam Jars) to make it from a wholesaler warehouse back to our corporate office.

I have three charts total:

Chart One: a bar chart that shows our days at the warehouse by count of orders pending and needs to remain STATIC (unchanged regardless of filters)

Chart Two: a Tree Chart to show the order distribution between each wholesaler (so we can see who has the most orders vs smallest).

Chart Three: The exact same as chart one, however i do not want this to be static and instead correlate with my tree chart selection

What the final results would look like:

Chart One gives me an understanding of overall, which is why it's important that it does not change.

Chart two will allow me to select wholesalers who have a higher volume in orders, then chart two will give me the ability to compare against my chart one.

Anyone can help?

5 Replies
Anonymous
Not applicable

You can make it happen using something called 'Set Analysis'.

Broadly, what you would do is in your first chart, change your measure function to include a set of explicitly selected options that ignores the current selection.

Here's an example:

Ignore selection in an expression (Set Analysis)

There are a lot of other resources to help you with this concept. If you can post a sample .qvf, or examples of your formula text we can help with syntax, should you need that.

shree909
Partner - Specialist II
Partner - Specialist II

Hello,

May be you can try using the Alternate states  or set analysis by ignoring all the fields.

Thanks

Sree

Greg_Williams
Employee
Employee

Kaitlyn -

Consider using Set Analysis to control what happens to your chart calculations when a selection is made. For instance, in chart one, you can use 1 in set analysis to avoid any selections impacting your chart - hence only showing a total. Set Analysis is VERY powerful.

Set Analysis Video:

Help System:

Introduction to Set Analysis (video) - Part 1

Check out the Guide: "Script Syntax and Chart Expressions"

http://help.qlik.com/en-US/sense/September2017/pdf/Script%20syntax%20and%20chart%20functions.pdf

Help System:

http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set...

There are a TON of resources available.

If you are new - I strongly recommend checking out:

joe_warbington
Luminary Alumni
Luminary Alumni

Totally agree! Be sure to check out my favorite utility: The Set Analysis Wizard. Helps you with examples and exposes the capabilities of this powerful function.

kaitlynwagner_s
Contributor II
Contributor II
Author

Awesome thank you so much! I think my biggest problem is not being familiar enough with what to research/google/youtube but these are great starts and I will definitely check them out!