find highest sales for each month in a time series bar chart

[arjunmadhusudan]

I have the following data:

Company	Month Year	Sales
a	Jan-17	10
a	Feb-17	20
a	Mar-17	11
a	Apr-17	13
b	Jan-17	40
b	Feb-17	45
b	Mar-17	2
b	Apr-17	4
c	Jan-17	55
c	Feb-17	3
c	Mar-17	40
c	Apr-17	1

I need a times series bar chart which has X axis = Month Year and  Y axis  =  Highest sale for that time period group by company

For example for Jan-17 I should get sale  = 55 which for company c.

[sunny_talwar]

We have no idea what you are seeing, do you mind sharing what you have so that we can figure out what might be wrong

[HarishG]

Create a variable like this,  vExclude=GetFieldSelections(Company),

in expression instead of sum(Sales), use below expression

Sum({<Company=-{'$(vExclude)'}>}Sales)

In above case, if you haven't selected anything in Company field, the charts shows the total of sales.

or

Simply use this =Sum({1-$}Sales), but if you don't select any value in company field, the calculation shows 0.

[qliksus]

Another way of doing it is as below

( (max({<Company=e(Company)>}Sales)=max({<Company=e(Company)>}total<MonthYear>Sales))* -1) * max({<Company=e(Company)>}total<MonthYear>Sales)

But both are gonna give the same result