Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

last one week data

Hi all,

gwassenaar

I need to display last one week data.

For example: Today is 25th i need to show last one week means from  18th to 24th.

Currently I am using,

Dimension as : Week_group

Measures as:

1.COUNT({<weekstart={">$(=date(max(weekstart)-7))<=$(=max(weekstart))"}, DateType={invitation}>}invitation_id)

2. COUNT({<weekstart={">$(=date(max(weekstart)-7))<=$(=max(weekstart))"}, DateType={signed}, user_signed={1}>}invitation_id)

but this is displaying the data of last week taking monday as weekstart.

anyone explain how can i display last 7 days/last week in single bar.

Thanks,

Pramod

Tags (1)
3 Replies

Re: last one week data

Can you post a Qlik Sense app that demonstrates the problem?

gardenierbi
Contributor

Re: last one week data

Why do you use 'Weekstart'? I think you want to compare with the date of today?

For example:

COUNT({<weekstart={">$(=date(TODAY()-7))<=$(=TODAY()-1)"}, DateType={invitation}>}invitation_id)

cjohnson
Contributor II

Re: last one week data

Hi Kumar,

Why don't you try introducing variables into your application as shown below:

image32.png

You can then use those variables in set analysis as shown below:

image33.png

Please see attached for more detail.

Thanks,

Camile