Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jfung148
Contributor

Creating Filter Groups? or something like that

hi all

i have a question.. i have a qv that loads a bunch of data points...

for example...   banana,grapes,apples,spinach,lettuce,cucumber,etc

how do i create a filter in qv to say fruit and ill tell it fruit includes this data set and veggies include this data set?

thanks

7 Replies
HirisH_V7
Honored Contributor

Re: Creating Filter Groups? or something like that

Hi ,

Check out attachment .

I think thats what you desired. !

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
alkesh_sharma
Contributor III

Re: Creating Filter Groups? or something like that

Its Possible in QV desktop Environment, but won't work if QVW is scheduled and filtered in changed from access point.

MVP
MVP

Re: Creating Filter Groups? or something like that

In script is simple,  add a new field

load

     field,      // banana, grapes, ...

     if(match(field, 'banana', 'apple', 'orange'), 'fruit',

     if(match(field, 'spinach', 'lettuce'), 'veggies ',

     'other'))  as  fieldtype

....

or you want allow the users to create the group without reload the app?

jfung148
Contributor

Re: Creating Filter Groups? or something like that

hi  hirishv7

i dont see any attachments..

thanks

HirisH_V7
Honored Contributor

Re: Creating Filter Groups? or something like that

Hi jackie,

Here is the attachment .

Hope this helps

HirisH
“Aspire to Inspire before we Expire!”
MVP & Luminary
MVP & Luminary

Re: Creating Filter Groups? or something like that

Hi Jackie,

if you still can't see attachments, it's probably because you open the thread from your Inbox. There is a glitch in the forum software that doesn't show attachments when you open the thread from the inbox. Click on the title of the thread on top of the list and follow this link to the actual discussion board. There, you will see the attachments.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView an...

Re: Creating Filter Groups? or something like that

Hi,

you could also load the fruit/vegetable classification in a seperate table like:

QlikCommunity_Thread_188948_Pic1.JPG

QlikCommunity_Thread_188948_Pic2.JPG

tabYourQVD:

LOAD RowNo() as ID,

    Ceil(Rand()*100) as SomeRandomFact,

    *

Inline [

Name

banana

grapes

apples

spinach

lettuce

cucumber

]

While IterNo()<=Rand()*5;

tabFruitVeggies:

LOAD * Inline [

Name,Type

banana,fruit

grapes,fruit

apples,fruit

spinach,vegetable

lettuce,vegetable

cucumber,vegetable

];

or joined to your QVD-table like:

QlikCommunity_Thread_188948_Pic3.JPG

tabYourQVD:

LOAD RowNo() as ID,

     Ceil(Rand()*100) as SomeRandomFact,

     *

Inline [

Name

banana

grapes

apples

spinach

lettuce

cucumber

]

While IterNo()<=Rand()*5;

Left Join (tabYourQVD)

LOAD * Inline [

Name,Type

banana,fruit

grapes,fruit

apples,fruit

spinach,vegetable

lettuce,vegetable

cucumber,vegetable

];

(Nevertheless Applymap (like already suggested by hirishv7) might be the better choice: Don't join - use Applymap instead)

hope this helps

regards

Marco