Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

current selection box

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

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

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

  1. 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
      ];
  2. 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

View solution in original post

4 Replies
sunny_talwar

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

Chanty4u
MVP
MVP

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

  1. 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
      ];
  2. 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
Not applicable
Author

Thank you!

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

Chanty4u
MVP
MVP

Yes...

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