Discussion board where members can get started with Qlik Sense.
i have two bar chart as below.
In first table, i want to show only 4 customers when their gross margin % is greater than 30% and sort them by customers with sum (revenue) in descending order.
Please find refer the attached qvf
thanks in advance
See attached qvf. Is that what you want?
No, i want sorting based on customers with their revenue when gross Margin % is greater than 30%
-> 4 customers with gross Margin % greater than 30%
-> they should be sort based on their sum(revenue) in descending order
Oh, i got a solution !
I have used the expression to customers by revenue.
Please close the thread by making correct and helpful answers.
sorry, though i was able to sort them by revenue with greater than 30% gross margin.
but still i am not able to define to show only 4 customers on bar chart.
Because the limit condition i have used to get customers more than 30%.
then how can i get only 4 customers