topic Re: Only Max and Min value for bar chart in QlikView

Only Max and Min value for bar chart

Sun, 20 Apr 2014 18:57:42 GMT

Hello All,

I have a customers data where i want to show only the maximum and minimum values of the sales value for the bar chart. only show max and min values not show all values.

Customer	Sales
John	450
Andrew	800
Mick	600
Alex	1500
Admin	700
Ales wan	900

Thanks

Re: Only Max and Min value for bar chart

its_anandrjs — Sun, 20 Apr 2014 19:07:50 GMT

Take a Bar chart and

Dimension:- Customer

Expression for Max :- if(Max (TOTAL Sales)=Sales, Sum(Sales))

Expression for Min :- if(Min (TOTAL Sales)=Sales, Sum(Sales))

Re: Only Max and Min value for bar chart

Sun, 20 Apr 2014 19:22:20 GMT

I dont want two expression i want to don this in single expression.

Re: Only Max and Min value for bar chart

Sun, 20 Apr 2014 19:27:35 GMT

Hi,

Use the same expression provided by anand as

=if(max (TOTAL Sales)=Sales, Sum(Sales),if(min(TOTAL Sales)=Sales,Sum(Sales)))

and remove the second one

Re: Only Max and Min value for bar chart

its_anandrjs — Sun, 20 Apr 2014 19:30:47 GMT

Thanks

Write this expression

Dimesnion:- Customer

Expression:- If(Min(TOTAL Sales) = Sales,sum(Sales),if(max(TOTAL Sales)=Sales, sum(Sales)) )

Re: Only Max and Min value for bar chart

maxgro — Sun, 20 Apr 2014 19:48:30 GMT

if(rank(sum(Sales))=1, sum(Sales),

if(rank(-sum(Sales))=1, sum(Sales)

))

Re: Only Max and Min value for bar chart

MK_QSL — Sun, 20 Apr 2014 19:57:04 GMT

Create a Straight Table

Dimension

Customer

Expression

=SUM({<Customer = {"=Rank(SUM(Sales))=1 or Rank(-SUM(Sales))=1"}>}Sales)

Re: Only Max and Min value for bar chart

Mon, 21 Apr 2014 17:21:48 GMT

Thanks all its very nice i come up with next question in same.

Re: Only Max and Min value for bar chart

MK_QSL — Mon, 21 Apr 2014 17:24:25 GMT

Kindly close this thread by selecting appropriate answer if your problem solved.