topic Re: IntervalMatch, Dimension from result expression in QlikView

IntervalMatch, Dimension from result expression

pirotfab — Wed, 16 Sep 2020 07:00:20 GMT

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

Re: IntervalMatch, Dimension from result expression

jerem1234 — Wed, 16 Sep 2020 18:43:21 GMT

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!

Re: IntervalMatch, Dimension from result expression

Kushal_Chawda — Wed, 16 Sep 2020 22:46:23 GMT

@pirotfab can you please elaborate with example?

Re: IntervalMatch, Dimension from result expression

pirotfab — Thu, 17 Sep 2020 08:09:35 GMT

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

Re: IntervalMatch, Dimension from result expression

Kushal_Chawda — Thu, 17 Sep 2020 09:13:09 GMT

@pirotfab what is expectations ? what is expected output?

Re: IntervalMatch, Dimension from result expression

pirotfab — Thu, 17 Sep 2020 09:46:43 GMT

I want the count of day per category, like this

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

Re: IntervalMatch, Dimension from result expression

Brett_Bleess — Thu, 24 Sep 2020 20:13:37 GMT

@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