Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Iwin
Partner - Creator
Partner - Creator

Dates Issue

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?

Labels (3)
1 Reply
Iwin
Partner - Creator
Partner - Creator
Author

Any way to solve this?

Tried using canonical dates but didnt work.

Attaching model  MODEL.png