topic Re: Last 5 week timestamp in calculated dimension in QlikView

Last 5 week timestamp in calculated dimension

deepakkrish — Fri, 15 Nov 2024 23:58:32 GMT

Hi,

I have a date filed called Timestamp , Timestamp fields is locked in my sheet.

So based on the selected timestamp I have to show previous 5 week trends.

I am using two expression one is applicable first 6 month and other one is applicable for july to this monday. can you help me to achieve this ?

if I get 5 week trends in dimension it would be easy I think

Regards,

Deep.

deepakkrish — Wed, 16 Sep 2020 07:29:14 GMT

deepakkrish — Wed, 16 Sep 2020 12:31:51 GMT

deepakkrish — Wed, 16 Sep 2020 13:51:47 GMT

=if(TimeStamp>=vMxfivedate and TimeStamp<=vMxYear, TimeStamp)

I tried this formula as well ,It's working if i clear the locked field.

How to show 5 weeks trend from the selected date

Regards,

Deep.