topic Bar chart with 2 dimensions (one calculated) in QlikView

Bar chart with 2 dimensions (one calculated)

Mon, 01 Nov 2010 17:45:36 GMT

How can I achieve this bar chart (stacked)

I have 2 dimensions :

the first is calculated

=if( TrancheHebdo <= 9 , 'Lundi à Vendredi' , if( TrancheHebdo=10 , 'Samedi Matin' , 'Samedi Après-Midi'))

The second is DOMAIN

The expression should be the % of sales for each value of DOMAIN

I know how to achieve is the first dimension is not calculated = Sum( Sales) / Sum( <MyFirtsDim > All Sales)

But with the formula I can't figure out to get the correct result. Of course, I don't want to create the dimension is the script.

Thanks for any help

Jean-Jacques

Bar chart with 2 dimensions (one calculated)

johnw — Mon, 01 Nov 2010 19:40:53 GMT

I tried and couldn't figure it out. What's bad about doing it in script?

Bar chart with 2 dimensions (one calculated)

Tue, 02 Nov 2010 12:58:09 GMT

I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).

I found out a solution but I don't like it. I just created one expression for each value of DOMAIN.

Thanks anyway JohnW

Bar chart with 2 dimensions (one calculated)

johnw — Tue, 02 Nov 2010 23:32:51 GMT


Jean-Jacques Jesua wrote:I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).

Ouch! Yeah, my worst load is about 3 hours, and I certainly hate making modifications to that script. Sorry I couldn't think of another solution. At least you figured out something that works, even if you don't like it.