topic Re: Set analysis, how to exclude data in QlikView

Set analysis, how to exclude data

Thu, 23 Jul 2015 09:08:33 GMT

Hello

I am working on a graph to show different actions, but i want to EXCLUDE the ones with the types called "Miscellaneous".

i have been this expression but i have an error message like Error in set modifier Ad hoc element list....any clue ????

=Count({<types=-{'Miscellaneous'>} distinct manif.K_ACTION)

thanks

Re: Set analysis, how to exclude data

Chanty4u — Thu, 23 Jul 2015 09:11:22 GMT

can u post the sample qvw?

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:13:13 GMT

Hi Jean-Philippe,

The correct syntax for the exlusion is:

=Count({<types -= {'Miscellaneous'} >} distinct manif.K_ACTION)

Greetz,

Marc Algera

Re: Set analysis, how to exclude data

arulsettu — Thu, 23 Jul 2015 09:13:42 GMT

try like this

=Count({<types=-{'Miscellaneous'}>} distinct manif.K_ACTION)

Re: Set analysis, how to exclude data

Kushal_Chawda — Thu, 23 Jul 2015 09:14:59 GMT

try,

you missed one '}'

Count({<types=-{'Miscellaneous'}>} distinct manif.K_ACTION)

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:17:30 GMT

just an FYI, maybe also worth saying this syntax will still highlight as incorrect but it is actually correct

Joe

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:23:18 GMT

thanks solved,

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:28:51 GMT

if you would like to exclude another types, you can add afterwards ? i need to exclude also "Others"

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:30:11 GMT

You can include yes, just add it as an extra entry in the set,

{'Miscellaneous','Others'}

Joe

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:36:52 GMT

mais oui of course...i think that i need a coffee

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:42:14 GMT

Now if i want to regroup 3 types Under 1 ...for exemple, i want to regroup under "Other" : others, no description, miscellaneous.

what would you recommend ?

Re: Set analysis, how to exclude data

Kushal_Chawda — Thu, 23 Jul 2015 09:44:56 GMT

You can include as many you want

Count({<types=-{'Miscellaneous','Others','No Description'}>} distinct manif.K_ACTION)

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 09:50:55 GMT

it is more "regroup" than include....

let s say i have data A, B and C and i would like to regroup them Under D.

Re: Set analysis, how to exclude data

Kushal_Chawda — Thu, 23 Jul 2015 09:55:52 GMT

in script do something like below

if(match(Type,'Miscellaneous','Others','No Description', 'Regroup',Type) as Type_new

Now you can do like

Count({<types=-{'Regroup'}>} distinct manif.K_ACTION)

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 10:06:35 GMT

here is my case..in the script

LOAD title,
types,
Name_company,
if(match(Name_company,'Fnac Rive','Fnac Balexert','Billeterie fnac', 'Regroup',Name_company)) as Fnac,
manif_in,
Year(manif_in) as Year,
Month(manif_in) as Month,

but NOT working , he does not like the line IF when i am doing the reload.

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 10:12:15 GMT

you've misplaced the closing bracket

if(match(Name_company,'Fnac Rive','Fnac Balexert','Billeterie fnac'), 'Regroup',Name_company) as Fnac,

give that a try

Joe

Re: Set analysis, how to exclude data

Kushal_Chawda — Thu, 23 Jul 2015 10:17:39 GMT

jphfavre‌i think JoeSimmons is right. You missed the bracket ')' of match

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 10:37:41 GMT

working

Re: Set analysis, how to exclude data

Thu, 23 Jul 2015 10:38:44 GMT

now in the result ....

how do i do to use this "regroup" action .....

Re: Set analysis, how to exclude data

Kushal_Chawda — Thu, 23 Jul 2015 10:43:22 GMT

Hi jphfavre ,

Use Fnac (which you have created in script) as dimension