Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display all values if one date is selected

Hi,

i have a little problem with line chart. I want it to display values for the period if the period is selected, but when a certain date is selected - i want it to display all values, ignoring any date selections.

Can anybody help?

Thanks in advance

1 Solution

Accepted Solutions
Not applicable
Author

You could just use this in your expression:

if(GetSelectedCount(Date)>1,sum(Sales),sum({1}Sales))

View solution in original post

4 Replies
Not applicable
Author

See the attached file.

I hope this is what you want.

I made only a couple of settings.

On general tab of the line chart, "GetSelectedCount(Date)<>0" means more than one value is needed to be selected in the list box of Date field to show this graph.

On expression tab, "Sum({1} Sales)" means this chart always shows all the data regardless of the selections in list boxes.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=If(Only(DateDimensionName) = '1/1/2014', Sum({<DateDimensionName=>}MeasureName), Sum(MeasureName))

Replace DateDimensionName with your date field, MeasureName with you measure and replace 1/1/2014 with your date.

Regards,

Jagan.

Not applicable
Author

You could just use this in your expression:

if(GetSelectedCount(Date)>1,sum(Sales),sum({1}Sales))

SunilChauhan
Champion
Champion

sum({1}sales) will block all you selection

please see the attched file

hope this helps

Sunil Chauhan