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

Qliksense - Chart with 2 dimensions, One Date & One Character

Hi everyone,

I am trying to build a stacked chart with 2 dimensions, one of which is a date and the other is a character.

Please find the attachment with the excel equivalent of what I am trying to achieve.

One thing I tried is creating a new dimension combining the two (Type&Date) but then the problem is the axis won't be sorted properly as the new variable will be a character and will ignore the date within.

Please, could anyone advise if there is a better way to achieve this ?

Thanks very much

Arun

2 Replies
sunny_talwar

What about doing it like this may be:

Dual(Type&Date, Date)

Gysbert_Wassenaar

Or maybe like this: Dual(Type & ' - ' & Date, FieldIndex('Type',Type)*100000 + Date)


talk is cheap, supply exceeds demand