topic 2 values with different dimension in one column in QlikView

2 values with different dimension in one column

petermoyaert — Wed, 10 Feb 2016 12:13:14 GMT

I would like to visualize the following

Dimension is month

jan/2016 feb/2016 mar/2016

Sales

Budget

Sales LY

Variance

Anyone a suggestion with regards to sales LY : so in the column of eg. jan/2016 I would like to visualize as well sales of LY and the variance against sales of jan/2016.

Re: 2 values with different dimension in one column

avinashelite — Wed, 10 Feb 2016 12:20:39 GMT

add Month and in the expression add>sum(Sales LY ) and sum(Variance)if Sales LY and Variance is a column

Could you please share the data so that it will be helpful for us to suggest the solution

Re: 2 values with different dimension in one column

swuehl — Wed, 10 Feb 2016 12:33:56 GMT

Create an AsOf Table, then you can use something like

Sum({<MonthDiff={12} >} Sales)

for previous year sales.

Variance:

=Sum({<MonthDiff={0} >} Sales) / Sum({<MonthDiff={12} >} Sales) -1

The As-Of Table