topic current selection box in QlikView

current selection box

Anonymous — Thu, 24 Mar 2016 17:56:01 GMT

Hi,

By default, QlikView displays values of a field inside a current selections box in the alphabetic order.

Is it possible to display the values in the Load Order?

Thank you in advance,

Larisa

sunny_talwar — Thu, 24 Mar 2016 17:58:17 GMT

I don't think Current Selections box can be played around with, but look at other alternatives here: Current Selection Alternatives

Chanty4u — Thu, 24 Mar 2016 18:14:08 GMT

yes.

chk dis

Purpose

The purpose is to be able to define the order in wich the selected dimensions will be displayed in the "Current Selection Box".

Steps

Start your load script with a "Load Inline" with the list of dimensions, in the order that you want in "Current Selection Box".
- CurrentSelectionBox_Order:
  LOAD * INLINE [ Currency, Country, State];
Drop this temporary table at the end of your script
- DROP Table CurrentSelectionBox_Order;

Summary

By default, selected dimensions are displayed in load order. With this tips, you define dimensions' load order, before loading data

Anonymous — Fri, 25 Mar 2016 09:12:49 GMT

Thank you!

But I was thinking not about the order of dimensions but the order of values.

Chanty4u — Fri, 25 Mar 2016 09:25:23 GMT

Yes...

i think it works for this also... u can try with sample once.