Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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
Contributor III
Contributor III

Any way to solve this?

Tried using canonical dates but didnt work.

Attaching model  MODEL.png