topic Group data with in the dimension in script in QlikView

Group data with in the dimension in script

kakani87 — Tue, 18 Sep 2018 11:24:33 GMT

I'm having country dimension with me

Country

spain

italy

france

germany

russia

i want to show in the filter all the countries and EU5 to be added as grouping all countries

Expected O/P

Country

spain

italy

france

germany

russia

EU5

using match () able to get EU5 but not able to show all the individual countries

if(Match(Country,'Spain','Italy','France','Russia','Germany' ),'EU5',Country) as Country

Re: Group data with in the dimension in script

MarioCenteno — Tue, 18 Sep 2018 14:32:49 GMT

May be try this

Pick(WildMatch([Country], '*Spain*', '*Italy*', '*France*','*Russia*', '*Germany*), 'EU5',Country) as [country]

Re: Group data with in the dimension in script

stigchel — Tue, 18 Sep 2018 15:01:24 GMT

In your example all countries fall into EU5, so you won't get the individual countries. If you want the individual countries as well as the grouping into one field concatenate load the country data once for the individual countries and once for the grouping. Load this as a seperate diemension table with an ID. Something like

Country:

Load *,RowNo() as ID;Load * Inline [Country

Spain

Italy

France

Germany

Russia

];

Concatenate LOAD ID,if(Match(Country,'Spain','Italy','France','Russia','Germany' ),'EU5') as Country Resident Country;

Re: Group data with in the dimension in script

vishsaggi — Tue, 18 Sep 2018 15:20:20 GMT

How is your EU5 linked to your other data? What should happen when you select EU5?

Re: Group data with in the dimension in script

kakani87 — Wed, 19 Sep 2018 06:13:38 GMT

HI Nagaraju ..

Actually all the countries falls under EU5 group, so we want to show in the filter EU5 including all the countries.

now comes to the purpose of this is to select all the individuals in a filter is possible, like so we want to add another thing which is equal to all the countries filtered i.e EU5.