topic Re: Pivot table - dimension repeat in QlikView

Pivot table - dimension repeat

Mon, 27 Oct 2014 06:37:24 GMT

below is the create table script

create table region (area varchar2(30), district varchar2(30), city varchar2(30));

insert into region values ('chandigarh', 'chandigarh', 'chandigarh');

insert into region values ('punjab', 'patiala', 'patiala');

insert into region values ('punjab', 'patiala', 'nabha');

insert into region values ('punjab', 'patiala', 'SAN');

insert into region values ('punjab', 'SAS', 'SAS');

insert into region values ('punjab', 'SAS', 'ZRK');

i added all column area , district, and city in dimension of PIVOT table

in city i have repeated values same reside in DISTRICT

i dont want to see highlighted values in red box in CITY column

how can i limit this from -CHART - DIMENSION - PROPERTIES

Re: Pivot table - dimension repeat

ashfaq_haseeb — Mon, 27 Oct 2014 06:43:40 GMT

Hi,

In script write below

If(district =city ,'',city ) as City

In chart suppress null values.

Regards

ASHFAQ

Re: Pivot table - dimension repeat

tresB — Mon, 27 Oct 2014 06:47:00 GMT

For CITY dimension use, calculated dimension: If(CITY<>DISTRICT, CITY), then in the dimension tab, select the expression and check 'Supress When Value is Null' .

Re: Pivot table - dimension repeat

Anonymous — Mon, 27 Oct 2014 06:50:00 GMT

Its showing because you have that particular value of patiala in district and city as well..

If you really want to omit it,then

instead of CITY as dimension use following as calculated dimension

if(CITY=DISTRICT,null(),CITY)

and Supress when Value is null(check the checkbox for this dimension)

PFA the example

Re: Pivot table - dimension repeat

Mon, 27 Oct 2014 06:51:04 GMT

thanks ashfaq, but i need to perform changes at chart level (properties).

Re: Pivot table - dimension repeat

ashfaq_haseeb — Mon, 27 Oct 2014 06:52:10 GMT

then

use this

if(CITY=DISTRICT,null(),CITY) as your calculated dimension and supress null values.

Regards

ASHFAQ

Re: Pivot table - dimension repeat

Mon, 27 Oct 2014 07:13:48 GMT

sorry guys still not working... i will back on same soon

thanks for being there

Re: Pivot table - dimension repeat

jagan — Mon, 27 Oct 2014 07:43:12 GMT

Hi,

In script try like this

LOAD

If(district <> city, 1, 0) AS Flag

FROM DataSource;

Now in chart try like this

Dimension: district, city

Expression:Count({<Flag={1}>}District)

Hope this helps you.

Regards,

Jagan.

Re: Pivot table - dimension repeat

Anonymous — Mon, 27 Oct 2014 09:16:51 GMT

Have you checked my example????

Re: Pivot table - dimension repeat

Mon, 27 Oct 2014 12:50:02 GMT

thanks i have checked ur answer ..

actullay i am writing the if statement in "Enable conditional" box,, i.e. where i performing wrong.