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

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

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

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