topic Re: Filter in QlikView

Filter

Thu, 29 Jan 2015 08:40:08 GMT

I have Inline dimension e.g,i used both in [food information] in filter in Sheets.....i used this filter in two sheet...In one sheet i show in filter

Apple and Mango.........And in second sheet i show all in items [Food Information] in filter......How can i achieve using same inline dimension.

[Food Information]

load * inline

[

Fruit

Apple

Mango

Graphs

Orange

]

mustafaelryah — Thu, 29 Jan 2015 08:55:31 GMT

Explore more Mr. Hammad

arulsettu — Thu, 29 Jan 2015 09:07:59 GMT

try this for first sheet

in list box->expression if(match(Fruit,'Apple','Mango'),Fruit)

second sheet display all data in listbox

Thu, 29 Jan 2015 09:50:16 GMT

Hi Arul,

By using ur expression I got the below results.

is it possible to show only apple and mango?

Thanks

Sudha

arulsettu — Thu, 29 Jan 2015 09:54:06 GMT

in list box istead of selecting filed select expression and use the above code

i got this

Thu, 29 Jan 2015 09:55:57 GMT

Hi,

define the expression as a field in the list box
=ValueList('mango','apple')

Thu, 29 Jan 2015 09:56:46 GMT

got your point.Thanks for you respsone arul.

arulsettu — Thu, 29 Jan 2015 09:58:57 GMT

my code is displays mtaching values from the field.

this one is like giving values in list.