Discussion Board for collaboration on QlikView Layout & Visualizations.
Hello Qlik Community,
i have got a question regarding sales of min and max month for each customer.
I want to show the the sales of the minimum month and the maximum month in a table. i Created some sample data
So for Customer A Min Month is January and Max month is April.
For Customer B Min Month is February and Max month is April
And so on.
I used the following expression in QlikView
It seems to work for minimum values, but for maximim values it shows only the sales of Customer E. Any idea why?
The result i would expect would be
I attached a sample file.
I really could use some help 🙂
Regards from Germany,
Go to Solution.
View solution in original post
Try with FirstSortedValue function
It works! Thanks!