Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to compare different values?
Lets say I select two different companies, would it be possible to see separate charts and tables for each selected company so that I could compare them visually?
Take a look at using Alternate States, its probably the quickest way to do what you are after.
Thanks
Steve
Hi,
Did you checked about the Trellis
Could it be done using Trellis chart? I just don't know if it's possible to use selected companies as a dimension
you could try set analysis and variables
selections by variables are usually independet from each other, so oyu could compare $vCompanyA
and $vCompanyB
IF(
sum({<[Monat_num]={$(vCompanyA)}>}Bundesl.SortNR)
=
sum({<[Monat_num]={$(vCompanyB)}>}Bundesl.SortNR),
'same','different')
If possible I would like to compare more than two companies. I have a box with all the companies so if the user selects 5 companies in that box, would it be possible to show 5 different charts?
Or would I have to limit the number of companies the user could select? And then have multiple listboxes where user selects one company in one box and then another company in another box?
I tried trellis and managed to get it to display charts for all selected companies but for some reason the charts look different if compared to a normal chart. Some of the expressions look the same but some are different. I have an idea it might be smth to do with set analysis which I'm using.
Yes
yes, both ways are possible.
you can compare as many companys as you like, but you have to define a max number.
you have to create as many charts and select boxes as your max number if you want to compare charts side by side.
but you can compare a variable number of values in one chart. then you only need 1 select box and 1 chart.
maybe this helps
http://community.qlik.com/blogs/qlikviewdesignblog/2012/05/25/a-closer-look-at-the-comparative-analy...