topic Re: How can to sum the value with period time & days? in App Development

How can to sum the value with period time & days?

attaporn — Sat, 16 Nov 2024 18:56:25 GMT

Hi All,

i would like to calculation of the value with period time & days as below:

1. Sum of KW, within 09:00 - 22:00 (only Monday to Friday)

2. Sum of KW, within 22:00 - 09:00 (Monday to Friday) & 00:00 - 24:00 (Saturday, Sunday & Holiday)

3. Max of average for KW every 15 minute, within 09:00 - 22:00 (only Monday to Friday)

to show on KPI visualization, Could you please help for expression script.......

BTW, the data as attached file: kw.csv in zip
and i think may be need to create new data for Holiday.

Example:
2020/01/01,New year
2020/12/25,Christmas Day

Best regards,

Vegar — Sun, 15 Mar 2020 10:55:33 GMT

One way of solving this is to create an intervalmatch on ofaå numeric field created by [weekday-num] + [time-fraction].

Take a look at the intervalmatch help section.

attaporn — Sun, 15 Mar 2020 16:19:50 GMT

Thank you for your suggestion, but I'm quite new in Qlik sense.

Please advise in advance for the detail and will be great if can have an example.

Vegar — Sun, 15 Mar 2020 22:22:11 GMT

See attached qvf.

I've not attempted to calculate no 3, but if you make 15 min intervals then you could do a count per interval-

(Im not suggesting that you should use Inline to define you intervals, you will need a way to create them autmaticly in your script)