topic Dynamic Dimension in lines in QlikView

Dynamic Dimension in lines

wunderch — Thu, 11 Oct 2012 13:31:45 GMT

Hi,

i have the following problem.

I have a Table like this:

Product	Sales	Cost 1	Cost 2
Jackets	100	20	50
Shoes	200	40	100

Now when I select for example Jackets I have to show it in a diagramm like this:

Dimension
Sales	100
- Cost 1	20
Result 1	80
- Cost 2	50
Result 2	30

Thanks for any ideas

Chris

Re: Dynamic Dimension in lines

jeffmartins — Thu, 11 Oct 2012 13:49:11 GMT

Hi,

You can create two tables and set the show condition to hide the first table when the product jackets is selected and show the second table. The show condition is on layout tab in the chart properties.

The condition for the first table could be GetSelectedCount(Product) <> 1 and for the second table GetSelectedCount(Product) = 1.

Regards

Re: Dynamic Dimension in lines

MayilVahanan — Thu, 11 Oct 2012 14:00:20 GMT

Are you expected like the attached file. (ValueList sheet)

Hope that helps

Re: Dynamic Dimension in lines

wunderch — Thu, 11 Oct 2012 14:20:38 GMT

Hi,

this is EXACTLY what I expected!

Thank you very much for the quick answer!!