Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Display all values if one date is selected

You could just use this in your expression:

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

4 Replies
Not applicable

Re: Display all values if one date is selected

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.

MVP
MVP

Re: Display all values if one date is selected

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

Re: Display all values if one date is selected

You could just use this in your expression:

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

chauhans85
Esteemed Contributor

Re: Re: Display all values if one date is selected

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

please see the attched file

hope this helps

Community Browser