QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Multiple Dimension Chart Issue

Hi,

I am having trouble applying variables across dimensions within a chart.

I have attached an example that has a sample set of data.  Essentially I want to apply a percentage to the count (based on product and range) whilst then showing the result by month and product.

I have tried this within an if statement and using input boxes, however I don't seem to be able to get it to work.

I would be grateful for any advise on this.

Many thanks

Tags (5)
1 Solution

Accepted Solutions
Valued Contributor II

Multiple Dimension Chart Issue

Hi,

try using this expression:

=sum(

aggr(

if(Product = 'A',

if(Range = '6 - 10', (( count(Case) / 100)* \$(A Range 6-10)),

if(Range = '11 - 20', ((count(Case) / 100)* \$(A Range 11 - 20)),

if(Range = '21 - 30', ((count(Case) / 100)* \$(A Range 21-30)), 0))) , 0)

+

if (Product = 'B',

if(Range = '6 - 10', ((count(Case) / 100)* \$(Other 6-10)), 0) ,0)

, Range, Product, Month)

)

Hope this helps you.

Regards,
Fernando

2 Replies
Valued Contributor II

Multiple Dimension Chart Issue

Hi,

try using this expression:

=sum(

aggr(

if(Product = 'A',

if(Range = '6 - 10', (( count(Case) / 100)* \$(A Range 6-10)),

if(Range = '11 - 20', ((count(Case) / 100)* \$(A Range 11 - 20)),

if(Range = '21 - 30', ((count(Case) / 100)* \$(A Range 21-30)), 0))) , 0)

+

if (Product = 'B',

if(Range = '6 - 10', ((count(Case) / 100)* \$(Other 6-10)), 0) ,0)

, Range, Product, Month)

)

Hope this helps you.

Regards,
Fernando

Not applicable

Multiple Dimension Chart Issue

Fernando,

I just checked this out; it works perfectly.  Thankyou very much for your help on this one.

Many thanks