Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Calculate weekly closures

Hi I am looking for some help on below. Scenario is that I want to capture weekly closures. I have data and desired output as per attached can you please throw some ideas.

Thanks

Mahesh

1 Solution

Accepted Solutions

Re: Calculate weekly closures

See attached qvw.


talk is cheap, supply exceeds demand
3 Replies

Re: Calculate weekly closures

See attached qvw.


talk is cheap, supply exceeds demand
MVP
MVP

Re: Calculate weekly closures

LOAD

  Date,

     Status

FROM

Example.xlsx

(ooxml, embedded labels, table is Sheet1);

dimension          =pick(match (week(Today()) - Week(Date),0,1,2,3), 'Current', 'PW', 'PPW', 'PPPW')

expression        count({$ <Status={Closed}>} Status)

                        count({$ <Status={Open}>} Status)

1.jpg

Not applicable

Re: Calculate weekly closures

Thank you guys for the idea

Community Browser