Current & Previous Week Calculations in Qliksense Table

SatyaPaleti — Sat, 16 Nov 2024 18:37:21 GMT

Hi Experts,

Need a small clarification. Actually we have a Product and it's Sales. Sales update every week. We want to show Current week and Previous week.

Load * Inline [

Product ,Q_Date, Sales

Mobile, 5/15/2020, 1098

Mobile, 5/08/2020, 1081

Mobile, 5/01/2020, 1062

So I am currently using following formula

For Current Week:

<[Week End]={"$(=Weekend(max(Q_Date)))"}>}Sales)

For Previous Week:

sum({<[Week End]={"$(=Date(Weekend(max(Q_Date-7))))"}>}Sales)

So when ever we doesn't make any selections. It displaying values perfect

Current week Last week.

1098 1081

but when I select date 5/08/2020

Current Week Last Week

1081 0

But it have to show following Values when i select 5/08/2020

Current Week Last Week

1081 1062

Can some one please help me on this to resolve this Issue.

Thanks and Regards,

Satya

Re: Current & Previous Week Calculations in Qliksense Table

Taoufiq_Zarra — Wed, 20 May 2020 00:47:23 GMT

can you share a sample data ? [Week End] field ?