topic Re: How to sort bars by measures level in Bar chart in App Development

How to sort bars by measures level in Bar chart

SatyaPaleti — Sat, 16 Nov 2024 19:39:53 GMT

Hi Folks,

Could some one help me on this following requirement.

How to sort bars by measures level in Bar chart. I am having a bar chart in the following

In the above chart if we look at dimensions Hard disk. Lower value is 4 and Actual is 0. So 1st bar should be Actual & 2nd bar should be Lower Value.

If we look at dimension USB Lower value is 20 & Actual is 17. So 1st bar should be Actual & 2nd Bar should be Lower Value.

There is one more Dimension Mouse. In this case 1st bar is Lower , 2nd bar is actual & 3rd bar is Upper. So these bar should be in ascending order. 1st bar should be Lower and 2nd bar should be Upper and 3rd should be Actual.

Could some one can please help me to resolve this Issue. Is this possible in Qliksense? Please let me know and you can find the data and sample qvf files in attachments

Thanks and Regards,

Satya

Re: How to sort bars by measures level in Bar chart

Gui_Approbato — Fri, 15 Nov 2019 15:15:47 GMT

Hello Satya,

Did you try changing the sorting options?

You can drag them up or down, accordingly to your preference in the hierarchy. Besides, you can also sort each one of them by an expression.

Inside your Product sorting option, check the expression box and write your measure there (choose ascending or descending).

Re: How to sort bars by measures level in Bar chart

SatyaPaleti — Mon, 18 Nov 2019 02:01:40 GMT

Hi Approbato,

Thank you so much for your response on this i have tried through sorting options which you explained but i unable to sort it. Could you please forward me the sample qvf file you are showing now. So that I will try to do the same in my appplications

Thanks and Regards,

Satya

Re: How to sort bars by measures level in Bar chart

Lisa_P — Mon, 18 Nov 2019 03:20:39 GMT

Re: How to sort bars by measures level in Bar chart

SatyaPaleti — Wed, 20 Nov 2019 02:39:17 GMT

Hi Approbato,

Could you please forward me that sample qvf. It's a very urgent requirement for me

Thanks and Regards,

Satya

Re: How to sort bars by measures level in Bar chart

Gui_Approbato — Wed, 20 Nov 2019 12:01:23 GMT

Hello Satya,

Your database is small so I don't think I would help sending back the qvf you sent.

I made a quick video to try to explain the sorting option. Check if it is clear.

Video: https://youtu.be/gKsS78V2Glg

Hope it helps!

Regards,

Re: How to sort bars by measures level in Bar chart

SatyaPaleti — Thu, 21 Nov 2019 03:13:05 GMT

Hi Approbato,

Thank you so much for the video. It really helps me. Thanks a lot for your contribution

Thanks and Regards,

Satya