Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-07-28 06:53 AM

Rolling up Data in Qlikview

Hello All,

I am currently facing some issue in creating a rolled-up view of the data I have. Given, I have the following data:

Element_Name     Remediation_Status     Severity_Level

E1                                 Step2                     Medium

E1                                 Step3                     High

E1                                 Step4                     Medium

E2                                 Step1                     Low

E2                                   -                              -

E2                                 Step2                     Medium

I have to create a rolled-up data such that for a given Element_Name, I have the lowest step for Remediation_Status and highest level of Severity_Level. The data should look something like this:

Element_Name     Remediation_Status     Severity_Level

E1                                 Step2                     Medium

E2                                 Step1                     Medium

Can this be done? Please Help!!

1,081 Views
0 Likes
11 Replies
Not applicable
‎2014-07-28 09:15 AM
Author

In response to MK_QSL

Got it!! It was the issue of quotes. Had to use single instead of double. Thanks you!!

149 Views
0 Likes
MK_QSL
MVP
MVP
‎2014-07-28 09:20 AM

In response to

Please close the thread by selecting appropriate answer.

149 Views
0 Likes
Community Browser