Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

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.

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

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)

View solution in original post

2 Replies
arulsettu
Master III
Master III

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
Creator II
Creator II
Author

Thanks Arul,

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

Regards