topic Re: Filtering records based on created dimension in QlikView

Filtering records based on created dimension

Anonymous — Fri, 16 Oct 2015 09:25:16 GMT

Hello everyone,

New dimension Freight 'TYPE' has been created based on the number of distinct Customer Groups on
Section Type 'OUT'. And it works just fine. However some freights have only section 'BH' like freight #5 in the attached
model.

I would like to classify such freights under following TYPE : 'Not_from_DC' and be able to select also those.

Anyone knows knows how to solve this?

Re: Filtering records based on created dimension

Qrishna — Fri, 16 Oct 2015 14:48:01 GMT

This way?

Re: Filtering records based on created dimension

miguelbraga — Fri, 16 Oct 2015 15:05:29 GMT

Hi Adam,

How about this?

See my calculated condition

Re: Filtering records based on created dimension

Anonymous — Fri, 16 Oct 2015 17:59:47 GMT

Wrong answer, if you click on No_from_DC it does not do anything, , But if you click on mixed'' then it selects only mixed freights , the same with dedicated- that part has been done

This is not an easy question

Re: Filtering records based on created dimension

Anonymous — Fri, 16 Oct 2015 18:01:18 GMT

yes, but try to click on Not_from_DC and when you see only the record Freight#5 then it is probably a good solution

Re: Filtering records based on created dimension

CELAMBARASAN — Fri, 16 Oct 2015 18:24:06 GMT

Hi,

Please check the attached one.

-Celambarasan

Re: Filtering records based on created dimension

Qrishna — Fri, 16 Oct 2015 18:29:13 GMT

See attached.

Re: Filtering records based on created dimension

maxgro — Fri, 16 Oct 2015 18:35:41 GMT

If I understand you want to group the not OUT records under Not_from_DC

Change to your script in bold

datld:

load * Inline [

Freight#,SectionType,CustomerGroup,COST

1,OUT,A,50

1,OUT,B,100

1,BH,X,150

2,OUT,A,100

2,BH,Z,100

3,OUT,A,100

3,BH,B,200

4,OUT,B,300

4,OUT,A,100

5,BH,S,50

];

nwtb:

load

count( distinct(CustomerGroup)) as GroupCnt,

Freight#,

SectionType

Resident datld

//Where SectionType='OUT'

Group by Freight#,

SectionType;

Left Join(datld)

load

if(SectionType='OUT',

if(GroupCnt>1,'Mixed','Dedicated'),

'Not_from_DC'

) as Type,

Freight#

Resident nwtb;

Re: Filtering records based on created dimension

Anonymous — Mon, 19 Oct 2015 13:56:24 GMT

Hi Krishna.

Your solution is also good.

Thanks

Adam

Re: Filtering records based on created dimension

Anonymous — Fri, 23 Oct 2015 10:29:05 GMT

Thanks Celembarasan!

But , what would be a solution in cases when there is a section OUT, but the cost = 0 or cost is empty

Such freights I would like to classify as 'not_from_dc' as well.

Thanks in advance for your help.