Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

Chart shows values for 2 dates

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.

SR chart.png

10 Replies
pradosh_thakur
Master II
Master II

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

regards

pradosh

Learning never stops.