This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to get Top 5 OtherBrandOwned and for those 5 top brands what are the Top 1 OtherModelOwned.
Data something like:
A3 Purchased - 3903
I am using text boxes to calculate these as we also need ratio of each value by Car Purchased - A3/A4/A6 etc.
I am able to get Top 5 OtherBrandOwned by using Rank() with Aggr() as shown above.
However, I am unable to get Top 1 Models for each of these Brands correctly.
For 4th Brand - Hyundai, I am getting model as 'Innova' which is incorrect.It should be Hyundai and Verna.
For 5th Brand - Maruti, I am getting model as 'Verna' which is incorrect.It should be Maruti and Swift.
How to customize the expression to get correct values for top 1 model. Please help.
Message was edited by: Nidhi Gupta
Thank you for sharing the application with sample data.
To fix this issue I have created variables to hold VehicleBrandName at various levels considering VehicleModelName and used those variables in the expressions.
Please refer updated application file attached herewith.
View solution in original post
Could you please share the application with sample data? This will help us to provide you required inputs.
Attaching sample qv file.
It was a challenge for me to put aggr() inside an aggr() function.
Your solution is spot on !! Thanks