Sorting in qliksense

[arusanah]

Hello Friends ,I'm  using a calculated dimension "Discharge Age Group".  I'm having hard time sorting it . it takes just first digit and sorts on that . where as I would like to sort it in sequence. any help is highly appreciated.

[kaushiknsolanki]

Hi,

There are 2 ways to do it.

1. From Script.

You can create a sorting in script using the same if statements you used for creating the bucket, or you can use inline load to assign the sort.

2. On Sort tab in chart.

You can choose "Sort by Expression" option and write your own sorting using if statements.

Regards,

Kaushik Solanki

[arusanah]

Hi Solanki ,

I did tried You can choose "Sort by Expression" option and write your own sorting using if statements., but it doesn't work.

[kaushiknsolanki]

Hi Can you tell us what expression you used.

Regards,

Kaushik Solanki

[sasiparupudi1]

What is the expression in Discharge Age Group? if possible, pl attach a sample