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

[#1]

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

[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)