Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Bar chart with 2 dimensions (one calculated)

Hi

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

3 Replies
MVP
MVP

Bar chart with 2 dimensions (one calculated)

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

Not applicable

Bar chart with 2 dimensions (one calculated)

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

JJ

MVP
MVP

Bar chart with 2 dimensions (one calculated)


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.