topic Re: Include few values form a dimension in QlikView

Include few values form a dimension

New-Qlik — Tue, 16 May 2017 05:28:45 GMT

Hello everyone

I have a requirement in which I want to include only few dim values example

Country

h etc

iw nat to see bar chart to show data for just A,B ,D,F,G H

I USED THIS IN DIM

if(country = 'A','B' ,'D','F','G', 'H'), country, '')

it didn't work. Kindly Guide

Anil_Babu_Samineni — Tue, 16 May 2017 05:32:13 GMT

Like this may be?

if(Match(country, 'A','B' ,'D','F','G', 'H'), country)

And do suppress null value for dimension

New-Qlik — Tue, 16 May 2017 05:36:52 GMT

thanks alot.. how can I forgett match u saved me

Anil_Babu_Samineni — Tue, 16 May 2017 05:38:07 GMT

Could be, And if you got answer please flag the Correct answer

New-Qlik — Tue, 16 May 2017 05:42:21 GMT

I am trying to find where to do

Anil_Babu_Samineni — Tue, 16 May 2017 05:43:30 GMT

Please read below

New-Qlik — Tue, 16 May 2017 05:52:27 GMT

I know this anil but that star symbol with correct is not coming somehow. I am sorry

Anil_Babu_Samineni — Tue, 16 May 2017 05:54:59 GMT

Let it be

vinieme12 — Tue, 16 May 2017 10:10:39 GMT

you should ideally be restricting the values using Set Analysis in the Expression

example

Dimension = Country

Expression = SUM({<Country={'A','B' ,'D','F','G', 'H'}>}Sales)