Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

need help

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 ?

3 Replies
pooja_prabhu_n
Creator III
Creator III

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.

Sort.PNG

Thanks,

Pooja

qlikapple
Creator
Creator
Author

it is not chnaging , can anyone please help

Frank_Hartmann
Master II
Master II

Sorting Expression:

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

hope this helps