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??
Do you try with max value?
ya i tried with that it didn't work out.i am new to qlikview.i want to know the highest sales
Can you attach your qvw file?
Try like this
Dimension : Country
Expression : Max(Sales)
Hope this helps you. If it not works can you attach some sample data.
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
On Right-top of the Posting textbox, click the Use Advanced editor link and then attach the files.
If you want to show highest sale in each country wrt customer...
Dimension = Country
Expression = MAX(Aggr(SUM(SALE),Country,Customer))
Retrieving data ...