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: 
josephinetedesc
Creator III
Creator III

To show a static total in a chart

hi

what I want is to allow users to select car type = Fords, but the total not to change ie to be static at 52 for example for the month of Jan.  At present I can get the total but if the users select Fords -it shows the Fords total, I want to see the Fords total in relation to the Total of all cars sold.

Thank you

Jo

Month1/01/20151/02/20151/03/20151/04/2015
Fords30403040
Holdens20302030
Kias2564
total52755674
12 Replies
MK_QSL
MVP
MVP

Where is Month/Date fields? What result you are expecting?

Check enclosed file. Is this what you are looking for?

fred_s
Partner - Creator III
Partner - Creator III

Hi Josephine,

I believe the Gauge does exactly what you want to achieve:

..how well each carmake is performing against the total of all cars sold..

fordnew.JPG

josephinetedesc
Creator III
Creator III
Author

I ended up using

Sum({$<CarMake={'Fords','Holdens','Kias'}>}NumSold)

the best tutorial ever was by Michael Tarallo:

https://www.youtube.com/watch?v=YMQJnKMkfxg

https://www.youtube.com/watch?t=171&v=nB-HJ8X1QbI

Jo