Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jjvicenza1930
New Contributor II

Dear experts

How can I exclude some field names in a dimension. For example: I want to present a graph of a Region consist of Europe, North America, Oceania, Asia, Not Relevant and blanc. I want to exclude Not relevant and blanc. I solved this by the following formular:

Sum({<APG_REGION_NAME = {"Europe", "North America", "Oceania", "Asia"}>} MARKET_VALUE_APG_BASE)/1000000

But I want to know how to exclude the names Not Relevant and the blanc field

Thanks in advance

Best regards

Xandro

9 Replies
MVP
MVP

Re: Dear experts

You already have solved this, right?

Sum({<APG_REGION_NAME = {'Europe', 'North America', 'Oceania', 'Asia}>} MARKET_VALUE_APG_BASE)/1000000

This isn't excluding Not Relevant and blanc?

jjvicenza1930
New Contributor II

Re: Dear experts

Yes

But I was wandering if there was an alternative method to exclude the two.

Best regards

Xandro

okolyug16
Contributor II

Re: Dear experts

Are you looking to exclude the fields completely from the data model? This can be done by commenting out the fields i.e //Not Relevant.

amartinez35
Valued Contributor

Re: Dear experts

Hi,

Sum(({<APG_REGION_NAME -= {'Not Relevant'}>} MARKET_VALUE_APG_BASE)/1000000

Not applicable

Re: Dear experts

Maybe this

Sum({<APG_REGION_NAME ={"*"}-{"Not Relevant"}>} MARKET_VALUE_APG_BASE)/1000000

MVP
MVP

Re: Dear experts

There is this:

Sum({<APG_REGION_NAME -= {'Not Relevant', 'blanc'}>} MARKET_VALUE_APG_BASE)/1000000

or

Sum({<APG_REGION_NAME = e({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000

jjvicenza1930
New Contributor II

Re: Dear experts

The field name Not Relavant and the blanc field name should be excluded from the dimension APG_REGION_NAME.

The field name Not Relevant can be excluded by the formular Sum({<APG_REGION_NAME -= {'Not Relevant'}. Now I am looking how to exclude the blanc field name. Is there a formular to exclude blanc field names.

Thanks in advance.

jjvicenza1930
New Contributor II

Re: Dear experts

I found the solution with thanks to all of you. The correct answer is:

Sum({<APG_REGION_NAME -= {"Not Relevant", ""} >} MARKET_VALUE_APG_BASE)/1000000

Thanks again to all of you for your support.

Best regards

Xandro

gompa786
Contributor III

Re: Dear experts

Hi,

Sunny's second condition below should work :

Sum({<APG_REGION_NAME = E({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000

Only please ensure how the Blank is defined ' ' or Blank or blanc etc... how is it appearing in the source..

Thanks