Discussion board where members can get started with QlikView.
I have a View from SQL Server database. It has fields like
With the help of above table I need to create a field which will display the Sales range for each Brand (Not Product)
My Table should look like
For Sales Range, my condition would be if the Sum(Sales)>100 for a particular Brand then Sales Range should have the value '>100'
This is how my Table should look
The solution would be an easy one. But I'm not sure how to do this in Qlikview. Any kind of help is much appreciated.
Share some sample data....
You may try like this at script level:
Use preceding load to calculate Range
Load Brand, if(Sales > 100,'>100',Null()) as Range;
Load Brand, Sum(Sales) as Sale
Group By Brand;
Then join with original table like:
If you wish to do the same at UI, then try with calculated dimention by using Aggr function.