Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trellis in Guage chart issue


Dear All,

I have attached QVW and unable to show the % of Contribution of Top 3 sales countries on each Guage Bottom.

SInce Country ranking will be dynamic I'm unable to show the percentage of each country on each guage.

I need to show % Of contribution as shown in below.

Capture.JPG

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

I think it is possible but maybe unnecessary complicate: you would need to integrate your dynamic dimension within your expression for the 'text in chart' expression. Then also take into account that the 'Text in chart' element is not dynamic in layouting  -e.g. if you change the dynamic dimension to show the top 4 or top 5 - you would have to adjust the expression and the layout manually. If there are only top 1 or top 2 - you also would have to layout it manually...so not really recommendable. Better use a simple bar chart or a straight table with mini gauges

View solution in original post

7 Replies
danieloberbilli
Specialist II
Specialist II

I think it is possible but maybe unnecessary complicate: you would need to integrate your dynamic dimension within your expression for the 'text in chart' expression. Then also take into account that the 'Text in chart' element is not dynamic in layouting  -e.g. if you change the dynamic dimension to show the top 4 or top 5 - you would have to adjust the expression and the layout manually. If there are only top 1 or top 2 - you also would have to layout it manually...so not really recommendable. Better use a simple bar chart or a straight table with mini gauges

Not applicable
Author

Hi,

Thanks for your reply.

I tried that dynamic calculation in text in chart. it is not working. as a cross verification I tried that calculation in text object which is not working for individual rank. but it is working for List box.

BR,

Neeru

danieloberbilli
Specialist II
Specialist II

Activate the Design grit (Strg+G) then click once on the object (chart) to activate it, then hold Ctrl+Shift...as you hold these two buttons the elements within the chart get a red frame and you can move them with the mouse like drag&drop to another position

danieloberbilli
Specialist II
Specialist II

it might be a bit tricky to layout this - if the chart looks to crappy, just go in chart properties > general tab > Reset User Sizing and Reset User Dockings buttons

Not applicable
Author

Hi,

You can see this qvd. I hope is correct answer.

Not applicable
Author

Hi Naidu...

Thank for your time...unfortunately country will be dynamic..I cannot use static country names for that..

Once again thanks for your time.

BR,

Chinna

Not applicable
Author

Hi,

If it is correct answer, click the correct answer.