Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

Dynamic creation of charts

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

1 Solution

Accepted Solutions
balabhaskarqlik

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.

View solution in original post

3 Replies
balabhaskarqlik

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.

View solution in original post

pooja_prabhu_n
Creator III
Creator III

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
Creator
Creator

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