Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions
qlikrajan
Contributor III

Re: Please help me in developing the ageing to my values?

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;

15 Replies
qlikrajan
Contributor III

Re: Please help me in developing the ageing to my values?

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

Re: Please help me in developing the ageing to my values?

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

qlikrajan
Contributor III

Re: Please help me in developing the ageing to my values?

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

MVP
MVP

Re: Please help me in developing the ageing to my values?

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

Re: Please help me in developing the ageing to my values?

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

That would be very helpful! Waiting for reply!

Thanks,

Raju

qlikrajan
Contributor III

Re: Please help me in developing the ageing to my values?

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

Re: Please help me in developing the ageing to my values?

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

Thanks for your support!

Not applicable

Re: Please help me in developing the ageing to my values?

Thanks for your inputs! Working!

qlikrajan
Contributor III

Re: Please help me in developing the ageing to my values?

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

Community Browser