Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

double entry table and set modifiers

Hello,

My data looks like the following table :

IDNew DateOld DateNew VersionOld Version
112/01/201811/01/2018ST1ST2
221/01/201821/01/2018ST2ST2
323/02/201822/03/2018ST2ST2

And I would like to have the following double entry table in my sheet in order to compare the new and the old data

VersionJanuaryJanuaryFebruaryFabruary
NewOldNewOld
ST11000
ST21222

The issue is that I have to select "new date" as a dimension but I need information from old date also.

So I tried the following expression to have data from "old date" : =Count( {<[Old Date.autoCalendar.Month] -= [New Date.autoCalendar.Month]> } ID)

But it doesn't work...

Do you have an idea to solve this issue ?

i thought about having a different table at the beginning but i need this layout to do other comparison...

Best regards

Caroline

1 Reply
sunny_talwar

I think you need to look at this thread

Canonical Date