Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
guster999
Contributor III
Contributor III

Qlik Sense adding YTD to bar chart with Months as dimension

Hi,

1.  I have the following measure for a bar chart that covers Jan16-Dec16 as dimension bars:

count({<Survey_Question={'3.Call taker'},Question_rating={5} >}[Question_rating])/count({<Survey_Question={'3.Call taker'},Question_rating={1,2,3,4,5,6} >}[Question_rating])

But I wish to add a bar to the right of these that is for YTD, how do I do this?

(my dimension is called SurveyDate which is in the form 'MMM-YY')

2.  I am also using colormix1 to get some color contrast with my bars - the problem is the range is only from 59%-69% for the months

- so I don't get mach of a color spread as it loos for a calculation between 0 and 1, any ideas on how to improve this?

colormix1(count({<Survey_Question={'3.Call taker'},Question_rating={5} >}[Question_rating])/count({<Survey_Question={'3.Call taker'},Question_rating={1,2,3,4,5,6} >}[Question_rating]),white(),rgb(0,173,104))

thanks

Gus

0 Replies