topic Re: How to pass week date in graph in QlikView

How to pass week date in graph

Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have to calculate Inactive user weekly where i have to pass either some static dates or dynamic date how to do that? as well as how to find inactive user?

sample.

User Name	User Type	Last Logon Date
SMDAGENT_P91	B	25.09.2015
SAPSUPPORT	S	18.09.2014
AAHNAJ	A	26.10.2015
AAKASHG	A	14.10.2015
AAKASHG2	A	21.10.2015
AAKRITIP	A	19.10.2015
AAKRITIV	A	23.10.2015
AALOKPRADEEY	A	16.10.2015
AAMERS	A	24.10.2015
AAMIRUDDINK	A	19.10.2015
AAMRAA	A	23.10.2015

static weekly date

Week	Date_Range_From	Date_Range_To
Week 1	09-09-2015	15/09/2015
Week 2	16/09/2015	23/09/2015
Week 3	24/09/2015	29/09/2015
Week 4	30/09/2015	10-06-2015
Week 5	10-07-2015	10-12-2015

how to give this static date in week.

Re: How to pass week date in graph

sunny_talwar — Wed, 13 Jul 2016 13:09:00 GMT

May be use interval match to assign a week to each row in your first table above

Re: How to pass week date in graph

fernando_tonial — Wed, 13 Jul 2016 13:09:42 GMT

Hi Priti,

You can try the function intervalmatch()

i.e.

Data:

LOAD * INLINE [

User Name, User Type, Last Logon Date

SMDAGENT_P91, B, 25/09/2015

SAPSUPPORT, S, 18/09/2014

AAHNAJ, A, 26/10/2015

AAKASHG, A, 14/10/2015

AAKASHG2, A, 21/10/2015

AAKRITIP, A, 19/10/2015

AAKRITIV, A, 23/10/2015

AALOKPRADEEY, A, 16/10/2015

AAMERS, A, 24/10/2015

AAMIRUDDINK, A, 19/10/2015

AAMRAA, A, 23/10/2015

];

Join (Data)

IntervalMatch ([Last Logon Date]) LOAD * INLINE [

Date_Range_From, Date_Range_To

09/09/2015, 15/09/2015

16/09/2015, 23/09/2015

24/09/2015, 29/09/2015

30/09/2015, 10/06/2015

10/07/2015, 10/12/2015

];

Left Join (Data)

LOAD * INLINE [

Week, Date_Range_From, Date_Range_To

Week 1, 09/09/2015, 15/09/2015

Week 2, 16/09/2015, 23/09/2015

Week 3, 24/09/2015, 29/09/2015

Week 4, 30/09/2015, 10/06/2015

Week 5, 10/07/2015, 10/12/2015

];

Don't worry, be Qlik.

Tonial.

Re: How to pass week date in graph

boorgura — Wed, 13 Jul 2016 13:10:38 GMT

You can use intervalmatch() function here.

Static_range:

LOAD * Inline [

week, from_date, to_date

.....

...

];

FactData:

LOAD LastLogonDate,

............

..........

.............;

intervatmatch(LastLogonDate) LOAD from_date, to_date from Static_range;

--------------------------------------

Edit: Oopss! 2 replies by the time I composed my reply!

Re: How to pass week date in graph

Thu, 14 Jul 2016 09:00:05 GMT

sorry for not making myself clear but i want for example:- if 100 user are total user out of which 50 are loged in that week the 50% will be inactive user how to populate that chart