topic Tips for a visualizations in QlikView

Tips for a visualizations

girard_ben — Sun, 03 Jul 2016 12:59:33 GMT

Dear all,

I'm looling for exchagne about a requirement about data presentation.

Currently we have this type of presentation (done manually)

the first row computes current data, and the second row computes Like For like data, to exclude closing store or opening stores in 2016

I can do the same with a standard Straight Table, it's working perfect.... but the layout is not the same...

and it's hard to to see at a glance Current value vs Like for Like value

I'm looking if somoene has an idea to treat this problem

Thanks in advance for your help;

Re: Tips for a visualizations

marcus_sommer — Sun, 03 Jul 2016 17:23:12 GMT

You need to add the Comparison like for like as an additionally values in your market-field and then you could query these value, for example:

if(market = 'Comparison like for like', exp1, exp2)

Another approach is to switch to a pivot-chart and adding a further dimension which could be queried with:

if(dimensionality() = 0, exp1, exp2)

A further approach (which I prefer) would be to display only one view at a time - one time the year-comparing overall and one time the cleaned year-comparing. For this you could use two objects maybe within a container - also the use of dimension/expression-groups is a possibility.

- Marcus

Re: Tips for a visualizations

girard_ben — Mon, 04 Jul 2016 06:30:19 GMT

Hi Marcus,

Two is better than one ... you give me the trick.. is to create a specific field to do the comparison... and it's fast to implement

Currently, my fact table has two columns : LFL_TY, LFL_LY (both columns has 1 or 0 values, it's calculated during the script load).. thoses two colums works perfectly well for other graphs..

The drawback of my idea... this will only compare Current Year vs Last Year (with the other method LFL_TY, LFL_LY , I can compare in a like for like analysis 2014 to 2013 ...for example)

I think I'll create a specific ComparisonTable to handle my presentation issue. I do not want to use a pivot table because it will be use in a NPrinting report ...