One dimension with multiple fields

[orlando162]

Dear all,

I'm a newbie in Qlik Sense.

I would like to combine 2 different dimensions into a single one. I have 4 fields:

- Expected Amount
- Expected Date

- Actual Amount
- Actual Date

My aim is to create a single bar graph where to show Actual vs Expected, considering a single Date dimension (obtained as combination of Expected Date and Actual Date).

i.e.  01/07/2021      100€ (actual amount)
        15/07/2021      10€ (expected amount)

         (graph)     jul 2021              100€ (measure 1)             10€ (measure 2)         

Thank you in advance for your help

[Andrea_Spinetti]

Hi @orlando162! You may find this thread useful for your request. Also, I would suggest having a look at this video on "Understanding the Master Calendar".