Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

eamritraz
New Contributor

To count active devices based on first update and last update

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

3 Replies
MVP
MVP

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

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

eamritraz
New Contributor

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

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.

MVP
MVP

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

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