topic Pie chart in QlikView

Pie chart

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

Hi,

I have created 2 pie chars inflight and completed. I have created two listbox showing weekending dates of the closed and start dates.

when I select a weekenddate in closed date the inflight pie chart must display the usercount which are in progress at that week.

I have attached the qvw file .

please help me solve this

Re: Pie chart

tresB — Tue, 21 Nov 2017 05:01:33 GMT

Select 'In_progress' status, you would see all closed date goes greyed out, that means the is no 'In Progress' users for closed dates in your sample data.

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 05:18:27 GMT

sorry..

I will attach another qvw showing weekend dates in list box.

in the closed dates weekending there is surely a startdate for in progress.

bt the data is not displaying

I want inprogress to show value irrespective of the date field selected

Re: Pie chart

tresB — Tue, 21 Nov 2017 05:25:17 GMT

Dhivya P wrote:

.... irrespective of the date field selected

Do you mean it would be same output when you select any date field as when no date is selected?

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 05:39:13 GMT

Hi Dhivya,

Find the attachment. Let me know if it is working for you

-Jai

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 06:06:53 GMT

when the closed date is selected the inprogress should show me which all user count are Inprogress at that time...

if this is not possible I atleast want to show the inprogress chart not affected on any closed date selection

I want to show atleast one of this..

Re: Pie chart

tresB — Tue, 21 Nov 2017 06:14:28 GMT

It's not about possibility here. Your data set doesn't have such records. However, if the second option you can go with you can bypass the selection in closed dt field using set like:

Count({$< [Closed Dt], STATUS={'IN-Progress'}>}DISTINCT [User-Story#])

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 06:24:17 GMT

thank you:)

this is one scenario what I wanted

I want to know if there is any possibility to show in progress chart only the user count records which have starting dates for selected closing date

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 06:25:20 GMT

thank you:)

Re: Pie chart

Anonymous — Tue, 21 Nov 2017 06:30:08 GMT

Hi ,

Can you lil bit elaborate about it.If possible

-Jai