Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouped Field

Hi Community,

I am struggling in creating a grouped field.

For example: I have a status column, where I have

In progress with management

In progress with the team

Provided

Delivered

In review

I need to create a separate column, where I would only have

In progress (which includes: In progress with management, In progress with the team,In review)

Delivered (which includes: Provided and Delivered)

Please advise on the best way to achieve it.

Thank you-

1 Solution

Accepted Solutions
sunny_talwar

Alternatively, you can use ApplyMap or a simple Inline load to do the same thing.

LOAD * INLINE [

status, New_Status

In progress with management, In Progress

In progress with the team, In Progress

Provided, Delivered

Delivered, Delivered

In review, In Progress

];

or


MappingTable:

Mapping

LOAD * INLINE [

status, New_Status

In progress with management, In Progress

In progress with the team, In Progress

Provided, Delivered

Delivered, Delivered

In review, In Progress

];


FactTable:

LOAD status,

          ApplyMap('MappingTable', status) as New_Status

FROM Source;

View solution in original post

8 Replies
sunny_talwar

Try like this:

LOAD status,

          If(Match(status, 'In progress with management', 'In progress with the team', 'In review'), 'In Progress', 'Delivered') as New_Status

FROM Source;

marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe something like this:

if(match(Status, 'Provided','Delivered'), 'Delivered', 'In progress') as [Status SubType]

- Marcus

swuehl
MVP
MVP

Maybe like

LOAD Status,

          If(Status LIKE 'In*', 'In progress', 'Delivered') as NewStatus,

     ....

sunny_talwar

Alternatively, you can use ApplyMap or a simple Inline load to do the same thing.

LOAD * INLINE [

status, New_Status

In progress with management, In Progress

In progress with the team, In Progress

Provided, Delivered

Delivered, Delivered

In review, In Progress

];

or


MappingTable:

Mapping

LOAD * INLINE [

status, New_Status

In progress with management, In Progress

In progress with the team, In Progress

Provided, Delivered

Delivered, Delivered

In review, In Progress

];


FactTable:

LOAD status,

          ApplyMap('MappingTable', status) as New_Status

FROM Source;

Not applicable
Author

what if i have a third group In Planning

sunny_talwar

Extend the if statement to the third group. or use ApplyMap as you can see above

Not applicable
Author

It worked! Thank you!

sunny_talwar

Awesome