Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Comparing different values

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?

8 Replies
sbaldwin
Contributor III

Re: Comparing different values

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

Thanks

Steve

Re: Comparing different values

Hi,

Did you checked about the Trellis

Not applicable

Re: Comparing different values

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

Not applicable

Re: Comparing different values

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

Not applicable

Re: Comparing different values

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?

Not applicable

Re: Comparing different values

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.

Not applicable

Re: Comparing different values

Yes

Not applicable

Re: Comparing different values

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

Community Browser