topic Problem regarding Pivot Table in QlikView

Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 07:00:18 GMT

Dear ALL ,

I want to design the Pivot table like below...

and i have made till here like below

I am not understanding how to design for FTNR % like above exel snapshot...can anybody please help me how to design the same as exel....below my file is attached for your reference and logic is as follows :

FTNR = count(DISTINCT {$<DISP_CATEGORY={'*'}>} SI_NO)

Inward = COUNT(DISTINCT SI_NO)

Regards

Sarfaraz

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 09:13:00 GMT

pls reply ...if know the resolution ....its urgent

sarfaraz

Re: Problem regarding Pivot Table

arulsettu — Tue, 16 Dec 2014 09:44:46 GMT

check the attached file of yours because it dose not have that much SUB_VERTICAL_DESC

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 09:52:34 GMT

Hi arul,

Thanks for your reply !!!!

The Sub_vertical_desc which attched exel sheet have is sample data ......i just want know how i can design the pivot table as per my expectation .....I tried that but failed to do so ....is there any way to achieve the same

Regards

Sarfaraz

Re: Problem regarding Pivot Table

saumyashah90 — Tue, 16 Dec 2014 09:53:20 GMT

I guess you have sent some other file...chan you please check and update it

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 09:56:27 GMT

Hi saumya,

the attched exel file is sample data .....i just want to design as per my expectation ....please suggest me a way to achieve the same ....

Regards

Sarfaraz

Re: Problem regarding Pivot Table

arulsettu — Tue, 16 Dec 2014 09:56:44 GMT

i assume to find FNTR % try like this

add another expression like this

count(DISTINCT {$<DISP_CATEGORY={'*'}>} SI_NO)/COUNT(DISTINCT SI_NO)

go to number tab and enable show in percentage

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 11:10:36 GMT

Dear Arul,

I know how to calculate for percentage ...my requirement is how i can get the design like exel snapshot in pivot table..

Sarfaraz

Re: Problem regarding Pivot Table

arulsettu — Tue, 16 Dec 2014 11:12:32 GMT

design means creating all the columns?

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 11:27:22 GMT

Design means how i can pivoting like above same as my exel snapshot.....i want entire sanapshot to be developed in pivot table ..

Sarfaraz

Re: Problem regarding Pivot Table

arulsettu — Tue, 16 Dec 2014 11:29:48 GMT

if you share the real excel it would be easy to do

Re: Problem regarding Pivot Table

sarfaraz_sheikh — Tue, 16 Dec 2014 11:41:11 GMT

Dear arun,

real exel is to large..my concern is to achive pivoting same as exel snapshot ...thats it .

Sarfaraz