topic Re: Creating Filter Groups? or something like that in QlikView

Creating Filter Groups? or something like that

Anonymous — Fri, 23 Oct 2015 21:47:57 GMT

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

Re: Creating Filter Groups? or something like that

HirisH_V7 — Sat, 24 Oct 2015 06:41:56 GMT

Hi ,

Check out attachment .

I think thats what you desired. !

Re: Creating Filter Groups? or something like that

alkesh_sharma — Sat, 24 Oct 2015 08:48:04 GMT

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

Re: Creating Filter Groups? or something like that

maxgro — Sat, 24 Oct 2015 09:05:01 GMT

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?

Re: Creating Filter Groups? or something like that

Anonymous — Sun, 25 Oct 2015 16:20:12 GMT

hi hirishv7

i dont see any attachments..

thanks

Re: Creating Filter Groups? or something like that

HirisH_V7 — Sun, 25 Oct 2015 18:16:02 GMT

Hi jackie,

Here is the attachment .

Hope this helps

Re: Creating Filter Groups? or something like that

Oleg_Troyansky — Sun, 25 Oct 2015 21:38:24 GMT

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 and Qlik Sense

Re: Creating Filter Groups? or something like that

MarcoWedel — Sun, 25 Oct 2015 23:02:21 GMT

Hi,

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

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:

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