topic Re: Chart shows values for 2 dates in QlikView

Chart shows values for 2 dates

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

Hi QV experts!

I have been asked to get record for Service which should have either the start date or completion date data. As you can see below, there are 2 for SR ID 7001231900 for start date (201502) and completed date (201601). But this should only show value for start date so that it should only have a bar chart with a value of 1.

This is the expression i used for this chart.

=Num(Count({$<[Service Request Start Date]>} DISTINCT [Service Request ID]),'#,##0') but still shows both values from 2015, 2016.

How can i make it to show just the value for start date? Thanks in advance for your assistance.

Re: Chart shows values for 2 dates

Anil_Babu_Samineni — Tue, 17 Oct 2017 01:21:28 GMT

Perhaps this?

If(GetFieldSelections([Service Request Start Date]) >1, Num(Count({$<[Service Request Start Date], CREATED_YEARMO = {'$(=Max(CREATED_YEARMO))'}>} DISTINCT [Service Request ID]),'#,##0'), Num(Count({$<[Service Request Start Date]>} DISTINCT [Service Request ID]),'#,##0'))

Re: Chart shows values for 2 dates

xarapre7 — Tue, 17 Oct 2017 03:31:55 GMT

Thank you for your reply Anil. I tried it but it didn't work. I'm still getting the same as above result.

Re: Chart shows values for 2 dates

Anil_Babu_Samineni — Tue, 17 Oct 2017 05:29:38 GMT

Will you able to provide mockup file to test?

Re: Chart shows values for 2 dates

xarapre7 — Tue, 17 Oct 2017 13:08:35 GMT

How can i attach the file in here?

Re: Chart shows values for 2 dates

xarapre7 — Tue, 17 Oct 2017 13:11:16 GMT

Here is the file. You'll see that the chart has multiple values for the yearmo but i only need to display the value for the startdate. Thanks for your help.

Re: Chart shows values for 2 dates

pradosh_thakur — Tue, 17 Oct 2017 13:40:43 GMT

pfa

regards

Pradosh

Re: Chart shows values for 2 dates

xarapre7 — Tue, 17 Oct 2017 14:48:01 GMT

sorry but what do you mean by pfa?

Re: Chart shows values for 2 dates

pradosh_thakur — Tue, 17 Oct 2017 15:02:01 GMT

please find the attached

Re: Chart shows values for 2 dates

xarapre7 — Tue, 17 Oct 2017 18:05:46 GMT

Thank you for your help! It worked.

Re: Chart shows values for 2 dates

pradosh_thakur — Tue, 17 Oct 2017 18:10:53 GMT

i guess you need to mark other's answer correct and helpful instead of yours and close the thread.

regards

pradosh