need help

[qlikapple]

hi i have data like this , it is in pivot table

dimension is

severity and month and expression as=count(DISTINCT{<[Testing]={'Yes'},Year = {$(vMaxYear)}>}OUT_ID)

The user requirement is he wants as HIGH Medium and low

How can i do ?

[pooja_prabhu_n]

Hi,

Create Inline table for sort order in the script

LOAD * Inline [

Severity, Sort order

High, 1

Medium, 2

Low,3

];

Sort the Dimension in the sort order.

Thanks,

Pooja

[qlikapple]

it is not chnaging , can anyone please help

[Frank_Hartmann]

Sorting Expression:

Match(Severity, 'HIGH', 'MEDIUM', 'LOW')

hope this helps