Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show a expression as a bar and the rest as dots

Hi,

I saw this interesting chart in a qview presentation.

01-06-2013 11-49-10.png

I have three fields (Year , Buget ans LastYear) and I would like to present Year like 'Actual' in the sample that is as a bar, and the other dimensions as dots like 'Ideal'.

How is it possible to present expressions like this?

Thanks.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Us a combi chart with only Stage (or whatever dimension you want on the x-axis) as dimension. Add three expressions:

Actual: sum(Year)

Budget: sum(Budget)

LastYear: sum(LastYear)

Choose Bar as display type for the Actual expression and for the two others choose Symbol. You can then select Dots as the symbol type. You can increas the symbol size on the Presentation tab if nessary.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Us a combi chart with only Stage (or whatever dimension you want on the x-axis) as dimension. Add three expressions:

Actual: sum(Year)

Budget: sum(Budget)

LastYear: sum(LastYear)

Choose Bar as display type for the Actual expression and for the two others choose Symbol. You can then select Dots as the symbol type. You can increas the symbol size on the Presentation tab if nessary.


talk is cheap, supply exceeds demand