topic Re: Comparing different values in QlikView

Comparing different values

Wed, 24 Apr 2013 11:25:23 GMT

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?

Re: Comparing different values

sbaldwin — Wed, 24 Apr 2013 12:59:34 GMT

Take a look at using Alternate States, its probably the quickest way to do what you are after.

Thanks

Steve

Re: Comparing different values

CELAMBARASAN — Wed, 24 Apr 2013 13:20:41 GMT

Hi,

Did you checked about the Trellis

Re: Comparing different values

Wed, 24 Apr 2013 13:51:43 GMT

Could it be done using Trellis chart? I just don't know if it's possible to use selected companies as a dimension

Re: Comparing different values

Wed, 24 Apr 2013 14:00:06 GMT

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')

Re: Comparing different values

Wed, 24 Apr 2013 14:14:38 GMT

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?

Re: Comparing different values

Wed, 24 Apr 2013 14:47:24 GMT

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.

Re: Comparing different values

Wed, 24 Apr 2013 15:01:40 GMT

Yes

Re: Comparing different values

Wed, 24 Apr 2013 15:07:07 GMT

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-analysis