Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Totals for 3 different barcharts

Hello ,

I have a requirement in my project where I need to compare sales vs budget for different zones on 3 different parameters viz : Month, last 3 months and year to date .

I am facing a problem when I use 3 horizontal bar charts in a container object for each parameter , I am unable to get the total value of all the zones , also if I select all zones the total should have ABI as label while if I choose individual zones , the zone name should be present in label , total in other cases .

Should I use straight table instead of using 3 bar charts ?

Can someone help me with this , attaching snapshot of the requirement .

swuehljagan

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Totals for 3 different barcharts

I used straight table with linear gauge and calculated dimension as a solution .

Will send a sample if someone wants .

6 Replies
Not applicable

Re: Totals for 3 different barcharts

Can someone please help me out , any suggestion is appreciated .

Re: Totals for 3 different barcharts

Shantanu,

Yes, is there any restriction to create the Straight table with those three expressions.

Try that way or send the sample application

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Totals for 3 different barcharts

Hello Anil ,

Thanks for the response , the issue with straight table is that I can't show values on the line gauge . One more issue is changing the total label based on the selection values :

if I select all zones the total should have ABI as label while if I choose individual zones , the zone name should be present in label , total in other cases .

I don't have a sample qvw readily available with me , please refer to the attached image .

Regards,

Shantanu

Re: Totals for 3 different barcharts

Can you please post the example

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Totals for 3 different barcharts

Attaching the snapshot .

I am not concerned about the formula/data values , just want a similar structure .

Not applicable

Re: Totals for 3 different barcharts

I used straight table with linear gauge and calculated dimension as a solution .

Will send a sample if someone wants .

Community Browser