topic Re: In bar chart , default line on the top in QlikView

In bar chart , default line on the top

ashis — Sat, 16 Nov 2024 03:43:25 GMT

Hi All,

I have city as dimension and sales as measure(=sum(sales))

In city we have

Boston,LA,Seattle and so on.

I want a bar chart that will show us the sales per city, however by default Boston should be always on the top of the bar chart.(even if the sales is less)

Then all other city would appear in descending order.

Is it do able ?

Kind regards,

Ashis

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 12:05:07 GMT

i guess i need to write this in sort tab

=sum({<city={'Boston'}>}Sale) , this will bring Boston on the top. However how to get other cities in descending order.

Re: In bar chart , default line on the top

Anil_Babu_Samineni — Mon, 29 Apr 2019 12:42:32 GMT

May be sort order as expression

Dual(Match(city, 'Boston'), city)

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 12:47:08 GMT

Thank you so much for your quick reply. It did not work though.

Re: In bar chart , default line on the top

Anil_Babu_Samineni — Mon, 29 Apr 2019 12:51:44 GMT

Can you share QVW file, meantime you can try this too with descending order

Match(city, 'Boston')

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 12:58:51 GMT

You can try;

city:

LOAD *

INLINE [ City, Sales Boston, 10000 LA, 26000 Seattle, 200 Washington, 500000 MA, 3000 ];

Bar chart:

Dimension - City

Expression =sum(Sales)

Re: In bar chart , default line on the top

arpitkharkia — Mon, 29 Apr 2019 13:30:06 GMT

Hi,

PFA, please note this may not be the best solution but it works the way you want it.

I have made a small edit to make it more robust. Please try! 🙂

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 13:47:03 GMT

Hi Arpit,

Thank you so much for your solution.

I am wondering why =maxsales (in text box) giving me error in expression. so does the the expression in sort tab.

Any idea.

Re: In bar chart , default line on the top

arpitkharkia — Mon, 29 Apr 2019 13:50:01 GMT

I have created a variable of maxsales where it is equal to sum(sales).

Im doing this so that Boston appears on the top of the graph.

I hope this makes sense.

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 13:50:23 GMT

I got it. It works now.

Thank you so much.

Re: In bar chart , default line on the top

ashis — Mon, 29 Apr 2019 13:51:04 GMT

I got it. It works now.

Thank you so much.