topic Re: Max and Min in same expression in QlikView

Max and Min in same expression

sivarajs — Wed, 11 Mar 2015 10:43:13 GMT

Hi,

I have a chart which values from low to high.The x axis has around 150 values so we reduced the size of chart. Because of that it showing first few values. Is there a way we can show min and max in same expression in between few values?

Regards,

Sivaraj

Re: Max and Min in same expression

robert_mika — Wed, 11 Mar 2015 10:45:14 GMT

Could you post an example?

Re: Max and Min in same expression

sivarajs — Wed, 11 Mar 2015 12:09:11 GMT

PFA's

Re: Max and Min in same expression

robert_mika — Wed, 11 Mar 2015 12:26:07 GMT

Try the attached

Re: Max and Min in same expression

sivarajs — Wed, 11 Mar 2015 12:34:30 GMT

how to achieve in same expression?

Re: Max and Min in same expression

robert_mika — Wed, 11 Mar 2015 12:38:49 GMT

Could you elaborate?

Re: Max and Min in same expression

sivarajs — Wed, 11 Mar 2015 13:03:01 GMT

The chart size what i have need not be changed. Because am displaying more number of chart in a sheet.

If you add more than a expression the legend will go (second dimension). I need to show those as well.

My question is, how to show max and min in same expression which i have used?

Re: Max and Min in same expression

gandalfgray — Wed, 11 Mar 2015 13:04:25 GMT

As I understand you, you want to see the chart values only for the min and max DATE in current selection.

If so, use this in the chart expression:

sum({<DATE={'$(=Date(min(DATE),'YYYY-MM-DD'))','$(=Date(max(DATE),'YYYY-MM-DD'))'}>}[Response Time])

(You should probably change the YYYY-MM-DD to fit your date format)

Re: Max and Min in same expression

tresB — Wed, 11 Mar 2015 13:09:31 GMT

Use calculated dimension, like:

=If(DATE=$(=Max(DATE)) Or DATE=$(=Min(DATE)), DATE)

PFA

Re: Max and Min in same expression

sivarajs — Wed, 11 Mar 2015 13:12:47 GMT

Max and Min is works fine. Can't we show trend between max and min? means some values in between.