Discussion Board for collaboration related to QlikView App Development.
We have a production tonnage every day:
03/01: 27 T ...
I want to dimension on a summary table, the number of days per tonnages produced
Sup 25T: 12d
Sup 27T: 8d
Sup 30T: 10d
Do you have any idea of the script?
i try a table intervalmatch but it's doesn't work
Not Exactly sure how your data looks, but if you have a date for each tonnage you might be able to just use count distinct like:
count(distinct Date) As Days
Group by Tonnage;
Hope this helps!
@Kushal_Chawda Just wanted to let you know the poster did come back with expected output if you have time to have another look at things. I am guessing the Community notifications are still not working all the time, sorry about that.