how to get highest sales chart??i want to know the highest sales across countries?how to get it?could anybody help me?

[#1]

how to get highest sales chart?i want highest sales across countries?how to get it?i used max expression.it didn't work out could anybody help me??

[javier_florian]

Do you try with max value?

[jagan]

Hi,

Try like this

Dimension : Country

Expression : Max(Sales)

Hope this helps you.  If it not works can you attach some sample data.

Regards,

Jagan.

[#4]

ya i tried with that it didn't work out.i am new to qlikview.i want to know the highest sales

[#5]

ya i tried with that it didn't work out.i am new to qlikview.i want to know the highest sales

[javier_florian]

Can you attach your qvw file?

[MK_QSL]

If you want to show highest sale in each country wrt customer...

Select Chart

Straight Table

Dimension = Country

Expression = MAX(Aggr(SUM(SALE),Country,Customer))

[#8]

hi jagan how to attach excel file and qlikview document.i can't see any option here.think is i have three regions.i want max value for each region and max value of all regions

[jagan]

HI,

On Right-top of the Posting textbox, click the Use Advanced editor link and then attach the files.

Regards,

Jagan.