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

Need help in bar chart

Hi QV,

In the attached sample, I need to show Total as constant even after any value selection in the list box.

Is it possible to show totals irrespective of any value selection.

Suppose

If I select Accenture in the list box, then in the chart I want to display one bar with accenture data and the other bar will display totals of all.

Thanks in advance..

Ananth

16 Replies
Not applicable
Author

Now my chart is not responding to any selections in the list box.

But it should reflect based on selection and grand total remains unchanged

tresesco
MVP
MVP

Have you taken two expressions?

Not applicable
Author

No, only one expression is there as I posted in the sample.

ashfaq_haseeb
Champion III
Champion III

Hi

go to chart properties--> dimension limit--> deselect show total.

Now add one more expression shown below.

=sum([Final Rm Rev Result])/sum( [Final Account Rm Rev Goal])

Regards

ASHFAQ

tresesco
MVP
MVP

Take two expressions (different) as I mentioned in earlier post when dimension would be [Property Name]

Not applicable
Author

Thank you very much tresesco, Now it's working as I expected

Not applicable
Author

Is it possible to display all the bars if there is no selection.

Now its giving grand total bar and selected value bar.

if there is no selection in the sheet, I would like to get grand total bar along with all the values bars.

Thanks,

Ananth