Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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