Discussion Board for collaboration on QlikView Scripting.
I want to substract two dates. And the output should be Number of Days.
I want to display it in a bar graph against dimension.
I used this as my expression
But i am getting No data to display.
It shows only when i select any field.
Help me with this.
Thanks and Regards
To get the date difference in days, just subtract the first date from the second.
You could round this with Round(), Floor() or Ceil() according to your requirements.
I am getting substracted date only when i select date received.
it should be displayed against a dimension in a chart.
How to do that ??
If there are multiple records for the dimension then you don't get data, try using
Hope it helps you.
What is the chart dimension? If the dates are not distinct per dimension line, you will to apply an aggregation function like Min() or Max().
chart dimension is insurer.
I have 7 insurer.
hi try this