Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Difference between two dates

Hi -

I am trying to create single line chart that will display the difference between Clearing Date & Posting date by Regrion. For some reasons when selecting one dimension and adding single calculated measure, values are not appearing on my chart.

Any help?

As my Dimension I am selection Region

and this is what i have for my expression:

interval("[Clearing Date].[Date].[Date].[MEMBER_CAPTION]"-"[Posting Date].[Date].[Date].[MEMBER_CAPTION]",'dd')

Thank you


3 Replies
Valued Contributor III

Re: Difference between two dates

Try the expression

Floor([Clearing Date]) - Floor([Posting Date])

Not applicable

Re: Difference between two dates

no that did not work.

Not applicable

Re: Difference between two dates

Here is an example of my file

Community Browser