Solution Needed in Expression...

Thu, 05 Feb 2015 13:53:31 GMT

Hello Everyone,

I have one column, 'Cause Code'. The few values of 'Cause Code' should be grouped together.

'Data Entry Issue', 'File Missing/Deleted', 'Data Exception' ,'Data Invalid Missing' should be grouped as 'Data Issue'.

The summed values should be shown against 'Data Issue'.

Can you please suggest me? Appreciate your valued suggestions.

Thanks.

Re: Solution Needed in Expression...

Gysbert_Wassenaar — Thu, 05 Feb 2015 14:03:49 GMT

One option is using an if statement:

LOAD

...some fields...,

if(match([Cause Code], 'Data Entry Issue', 'File Missing/Deleted', 'Data Exception' ,'Data Invalid Missing'), 'Data Issue' , [Cause Code]) as [Cause Code],

...some more fields...

FROM ....

Instead of arranging this in the script (as you should) you can also use the if statement as a calculated dimension.

topic Solution Needed in Expression... in QlikView

Solution Needed in Expression...

Re: Solution Needed in Expression...