topic Re: Dates Issue in QlikView

Dates Issue

Iwin — Wed, 16 Jun 2021 17:11:30 GMT

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?

Re: Dates Issue

MarcoWedel — Wed, 16 Jun 2021 23:43:07 GMT

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

Re: Dates Issue

Iwin — Thu, 17 Jun 2021 10:17:55 GMT

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 ?

Re: Dates Issue

Iwin — Thu, 17 Jun 2021 19:04:05 GMT

Any way to solve this?