topic need help in QlikView

need help

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 19 Sep 2018 10:03:07 GMT

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 — Thu, 20 Sep 2018 11:43:48 GMT

it is not chnaging , can anyone please help

Frank_Hartmann — Thu, 20 Sep 2018 12:15:28 GMT

Sorting Expression:

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

hope this helps