This content has been marked as final. Show 3 replies
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
|Customer||Min Month Sales||Max Month Sales|
I attached a sample file.
I really could use some help :-)
Regards from Germany,