Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pirotfab
Creator
Creator

IntervalMatch, Dimension from result expression

We have a production tonnage every day:

01/01: 28T
02/01: 30T
03/01: 27 T ...

I want to dimension on a summary table, the number of days per tonnages produced

ex:
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

thanks

 

6 Replies
jerem1234
Specialist II
Specialist II

Hi Pirotfab,

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:

Table1:

Load

Tonnage,

count(distinct Date) As Days

Resident DataTable

Group by Tonnage;

Hope this helps!

Kushal_Chawda

@pirotfab  can you please elaborate with example?

pirotfab
Creator
Creator
Author

Hi @Kushal_Chawda and @jerem1234 

Thanks you for you answer

For each date, it's a su of several production stations

Attached a database.

Thanks

Kushal_Chawda

@pirotfab  what is expectations ? what is expected output?

pirotfab
Creator
Creator
Author

I want the count of day per category, like this

 

month    <27T          >27T        >28T          >29T         >30T
jul.                9                5                 5               9                  3

 

Brett_Bleess
Support (Former)
Support (Former)

@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.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.