Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help me in developing the ageing to my values?

Hi All,

I have values in my field Level as below.

Level

Sev 1

Sev 2

Sev 3

Sev 4

Now i want to group the values sev1, sev2, sev3 as priority 1 and  sev4 as priority 2.


Atlast i want to display the listbox  as priority

Priority

Priority 1

Priority 2

So that we can get the data by priority level on dashboard.

Can anyone please advice on this?

Thanks in advance!

Raju

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This is the script that I used. I am still seeing the app (sample) that I attached.

Level:

LOAD * INLINE [

    Level

    Sev1

    Sev2

    Sev3

    Sev4

    Sev1

    Sev3

    Sev1

    Sev4

    Sev3

    Sev2

];

Load *,

if(Match(Level,'Sev1','Sev2','Sev3'),'Priority1', 'Priority2') as Priority

Resident Level;

View solution in original post

15 Replies
Anonymous
Not applicable
Author

You can create another column 'Priority' in script where if the level is Sev1 to Sev3 then assign it a value Priority 1 and if the level is Sev4  then Priority 2. Create a list box using new field Priority.

Hope this helps. Let me know if you have nay questions.

Not applicable
Author

Thanks for response Rajan! Can you please provide me in detail script.

Anonymous
Not applicable
Author

Please find the sample qvw attached. I created a sample table that has only one coulmn Level and then added another column Priority.

maxgro
MVP
MVP

load

  Level,

  pick(match(Level, 'Sev 1', 'Sev 2', 'Sev 3', 'Sev 4'), 'Priority1', 'Priority1', 'Priority1', 'Priority2') as  Priority;

load * inline [

Level

Sev 1

Sev 2

Sev 3

Sev 4

];

Not applicable
Author

Attachment not found in your response! If possible provide me screenshot.

That would be very helpful! Waiting for reply!

Thanks,

Raju

Anonymous
Not applicable
Author

This is the script that I used. I am still seeing the app (sample) that I attached.

Level:

LOAD * INLINE [

    Level

    Sev1

    Sev2

    Sev3

    Sev4

    Sev1

    Sev3

    Sev1

    Sev4

    Sev3

    Sev2

];

Load *,

if(Match(Level,'Sev1','Sev2','Sev3'),'Priority1', 'Priority2') as Priority

Resident Level;

Not applicable
Author

Super Rajan! Its Working I spent lot of time on this!

Thanks for your support!

Not applicable
Author

Thanks for your inputs! Working!

Anonymous
Not applicable
Author

Hey Raju...If you find that answer is helpful or correct could you mark the answer likewise and close the thread. Thanks