Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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')
Try the expression
Floor([Clearing Date]) - Floor([Posting Date])
no that did not work.
Here is an example of my file