How to pass week date in graph

[#1]

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.

[sunny_talwar]

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

[fernando_tonial]

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.

[boorgura]

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!

[#5]

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