Discussion board where members can get started with Qlik Sense.
Last AGGR function is used for sum of Quantity for each product and divide by 2 is my bench march for that product. i want to compare value for each customer
Product A Bench mark sales is 35
All customer bought the qty below 35 so i want color it(Customer A,B,C,D)
Product B Bench mark sales is 50.
Customer A and Customer F I want to color it
Go to Solution.
Try adjusting your expression with NoDistinct like this:
View solution in original post
Is there any possible to hide Customer E Transaction in front-end??
No I'm not asking like that
Now the transaction table comes like this.
If Qty and AGGR(Nodistinct Sum(Qty)/2,Product) column is equal or above the value that transaction i want to remove in my front end it is possible??
Anyone is this possible???