Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Not applicable

Getting only one value dimension for chart.

Hi ,

I have a Fruits column, where

Dimension: Fruits

FruitsID Fruits

  1             Apple

  2             Banana

3               Mango

4              Organe

In this i need to get only one fruitname to display in dimension.How could i display, or add equation in dimension so it only chooses only required fruits name

Please help me. Any help is appreciated.

Tags (1)
1 Solution

Accepted Solutions
arulsettu
Not applicable

Re: Getting only one value dimension for chart.

if you want to display only one fruit in dimension

you can try in dimension like this

if(match(Fruits,'Apple'),Fruits)

or

in expression

count({<Fruits={'Apple'}>}sales)

2 Replies
arulsettu
Not applicable

Re: Getting only one value dimension for chart.

if you want to display only one fruit in dimension

you can try in dimension like this

if(match(Fruits,'Apple'),Fruits)

or

in expression

count({<Fruits={'Apple'}>}sales)

berryandcherry6
Not applicable

Re: Getting only one value dimension for chart.

Thanks Arul,

I choose first expresion, as i need to put in Dimension.

Regards