topic Display all values if one date is selected in QlikView

Display all values if one date is selected

Fri, 02 May 2014 04:08:57 GMT

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

Re: Display all values if one date is selected

Fri, 02 May 2014 04:47:12 GMT

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.

Re: Display all values if one date is selected

jagan — Fri, 02 May 2014 05:13:06 GMT

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.

Re: Display all values if one date is selected

Fri, 02 May 2014 06:10:55 GMT

You could just use this in your expression:

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

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

SunilChauhan — Fri, 02 May 2014 06:22:49 GMT

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

please see the attched file

hope this helps