Dates Issue

[Iwin]

Hi all,

I have a table which consists of 2 expressions Actual Cost and Revenue.

Issue is Actual Cost value appears correctly only when date field Project Start Month is used as dimension while Revenue value appears correctly when CALDATE is used as dimension.

I want to show both expressions in a single table but both should work as per their respective date field.

I cannot use both the dimensions together.

Is there way to show correct values in above situation in a single table only?

[MarcoWedel]

Hi,
you can create a canonical date in this case:
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

hope this helps

regards

Marco

[Iwin]

Hi Marco,

I tried making changes as per the article but still values remain same.

Here is a glimpse of my model.

Can you suggest anything ?

[Iwin]

Any way to solve this?