topic To count active devices based on first update and last update in QlikView

To count active devices based on first update and last update

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am getting data from 100 of devices and i want to show a line graph showing the count of active devices at week and month level, we have 'first data sent' and 'last data sent' as data points and we consider device to be active between this two data points. kindly guide me how to do it in qlikview, if there is processing needed i can use alteryx

[Device id] [first data sent] [last data sent]

1 05/01/2018 06/02/2018

2 05/02/2018 06/01/2018

3 05/03/2018 07/05/2018

4 04/01/2018 07/09/2018

5 03/01/2018 07/15/2018

Re: To count active devices based on first update and last update

sunny_talwar — Fri, 10 Aug 2018 16:26:22 GMT

Use IntervalMatch to join the above table to the master calendar and then you can week as a dimension and Count(DISTINCT [Device id]) as an expression

Re: To count active devices based on first update and last update

Anonymous — Wed, 22 Aug 2018 12:17:09 GMT

Hi Sunny,

Thanks for the help, there is a synthetic key generated when i am using interval match and not the linking as shown in the document.

Re: To count active devices based on first update and last update

sunny_talwar — Wed, 22 Aug 2018 12:18:54 GMT

not the linking as shown in the document.

Not linking to what? I am not sure I understand...

there is a synthetic key generated when i am using interval match

synthetic key should be okay as pointed out by HIC in the blog post above