Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Sorting issue in bar chart

hi Everyone,

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

Sortin.JPG

5 Replies

Re: Sorting issue in bar chart

See attached qvf. Is that what you want?


talk is cheap, supply exceeds demand
Not applicable

Re: Sorting issue in bar chart

No, i want sorting based on customers with their revenue when gross Margin % is greater than 30%

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.

-> 4 customers with gross Margin % greater than 30%

-> they should be sort based on their sum(revenue) in descending order

Not applicable

Re: Sorting issue in bar chart

Oh, i got a solution !

I have used the expression to customers by revenue.

thanks

sureshqv
Esteemed Contributor III

Re: Sorting issue in bar chart

Great.

Please close the thread by making correct and helpful answers.

Not applicable

Re: Sorting issue in bar chart

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

Community Browser