topic Re: Expression, show data acording to date. in QlikView

Expression, show data acording to date.

goro2010 — Mon, 08 May 2017 10:33:13 GMT

Good Day Everyone,

I am trying to do an expression that only rely on your date selection.

Currently my sum expression takes all the volumes of "qty" and give me the sum, regardless if you have selected a date or not.

I need the sum to be zero if no date have been selected, and only work out the sum of the date and / or date range that I have selected.

Is this possible?

Thank You!

tresB — Mon, 08 May 2017 10:39:42 GMT

May be like:

If( GetSelectedCount(DateField), <Your expression>,0)

goro2010 — Mon, 08 May 2017 10:44:06 GMT

Brilliant, thank you for the quick response. I get now that the values is showing all zero's, but once I select the date now, I get all values -1.

Here is my expression: =If(GetSelectedCount(OrderDate), Sum(qty),0 )

Thank You!

awhitfield — Mon, 08 May 2017 10:46:09 GMT

Hi Jan,

I Guess one way is to add a calculation condition, so the chart isn't calculated at all until you select a date:

Then add a Custom error Message e.g. please select a date....

Andy

Kushal_Chawda — Mon, 08 May 2017 10:46:34 GMT

try this expression

=sum(Sales) * if(GetSelectedCount(Date)>0,1,0)

Note: Also, go to presentation tab of chart, and uncheck Suppress zero values , to show 0 values on chart

goro2010 — Mon, 08 May 2017 10:52:02 GMT

Hello, I have found that there was an issue with my expression, it is working brilliant now! - Thank You

goro2010 — Mon, 08 May 2017 10:52:41 GMT

Also working - Thank You