Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

poluvidyasagar
Contributor

Calculated Dimension using ONLY function?

Hi,

I am trying to achieve the following:

Sample Data:

LocationSublocationPart
AA112345
BB123456
BB212456
CC114678
CC218992
DD118320
DD210302
ABAB110320
ACAB213920
ADAB310401

My Dimensions are:

1. Location

2. Sublocation

However, I do not want to show all Locations as my dimension. I would like to use ONLY function with set analysis ?

I have tried the following but it does not seem to work:

Only ({<{Location-={'AB','AC','AD'}>}Location}

Basically i do not want to show locations with AB, AC, AD. Since this is a sample data set, i am only showing few location. However, i have quite a few locations that i want to show and exclude some. That is why i am going with not contain in set analysis.

Can someone help me on this?

I have attached the sample file.

Thanks,
Vidya

Tags (1)
18 Replies

Re: Calculated Dimension using ONLY function?

Try this

if(wildmatch(Location,'AB','AC','AD'),Location)

Regards,

Regards,
Prashant Sangle
poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

It does not work

poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

stalwar1

Hi Sunny,

Can you help me on this one?

MVP
MVP

Re: Calculated Dimension using ONLY function?

Try this:

Aggr(Only ({<{Location-={'AB','AC','AD'}>} Location), Location)

neelamsaroha157
Valued Contributor II

Re: Calculated Dimension using ONLY function?

Check this out...added expression with if condition as well as set analysis.

poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

It does not work

poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

I can't see anything attached

poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

This worked for me:

=if(Not Match(Location, 'AB','AC','AD'),Location)

Check suppress when value is null

poluvidyasagar
Contributor

Re: Calculated Dimension using ONLY function?

I would still like to see if this can be achieved using Only function with set analysis

swuehl

Community Browser