topic Weekly report in Qlikview in QlikView

Weekly report in Qlikview

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

I am new to Qlikview. I need to create a report of a column , with count of status=completed for a weekly period - each week.

I referred to some of the existing threads but those didn't help much. Please help

So that chart that i am looking for is , week / status completed count

Re: Weekly report in Qlikview

Vegar — Fri, 27 Sep 2019 17:46:34 GMT

Create a chart put Week as a dimension and use the following expression.

Count( {< Status= {'Complete'}>}Status)

Re: Weekly report in Qlikview

qlikvw2019 — Fri, 27 Sep 2019 17:59:26 GMT

Thankyou for the response.

I missed mentioning in my earlier email. I don't have any column such as "week", i have a column, as event_date. So here is the sample data. I am looking for a chart which can display each week on one of the axis and count of status =completed for each week as another axis

Event_date	Status
9/27/2019	COMPLETED
8/27/2019	PENDING
4/12/2019	COMPLETED
5/9/2019	COMPLETED
6/29/2019	PENDING
3/29/2019	COMPLETED
1/30/2019	COMPLETED

Re: Weekly report in Qlikview

Frank_Hartmann — Fri, 27 Sep 2019 18:07:56 GMT

see attached qvw.

hope this helps

Re: Weekly report in Qlikview

Brett_Bleess — Tue, 08 Oct 2019 15:21:56 GMT

Nazneen, did Franks' last post with his example app work for you? If so, please be sure to circle back and use the Accept as Solution button on his post to mark that as the solution and give him credit for the help with things. If you are still working on things, leave an update.

Just for future reference, you can try the Design Blog area for examples and how-to related posts, these are specifically from Qlik Employee experts, the link below is the base link, use the search dialog to look for posts related to the top you are trying to figure out.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett