Dynamic creation of charts

[sagar_vij99]

Hi All,

I am making a dashboard in which i want to keep creation of my charts dynamic.

I have data in which I have some Products and each product have some processes. Now different products can have different number of processes.

What i am trying to do is - I want to give a filter for products value and when a user selects a product its corresponding processes should come in charts as dimension and expression for all will be same.

For example : if my product A has 3 processes a,b,c and my product B as 2 processes x,y.

Now when i select A from filter i should get 3 charts with dimension a in chart 1, b in chart 2 and c in chart 3. And expression for all 3 is sum(volume).

If i select B now from filter i should get 2 charts with dimension x in chart 1, y in chart 2. And expression for both charts is sum(volume).

Is it possible to achieve in Qlikview. Or any alternate/closest solution I can have..??

Any help will be appreciated..!!

Regards

Sagar

[balabhaskarqlik · Accepted solution]

Trellis chart option will help you, to get the required data.

Check this.

http://buffalobi.com/qlikview/qlikview-trellis-chart/

Add the Dimensions, select data, see generated charts.

[pooja_prabhu_n]

Hi,

You can try using Trellis chart and use conditional display of charts.

=if(GetFieldSelections(Product)>0,1,0)

Please refer the attached file.

Hope this helps

Thanks,

Pooja

[sagar_vij99]

This is what i needed. Thanks for the prompt reply...!!