Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tyagishaila
Specialist
Specialist

sum in pivot table

I want this type of pivot table in qlik view

here year wise F and M sum is total 100% but when I did it I got correct result if I show on 1 year info as I select more then 1 yr then total % divided into two years.

i.e. YTD 11-12 and YTD 12-13 total % sum is 100% irrespect to each YTD.

6 Replies
arulsettu
Master III
Master III

can you provide data source

tyagishaila
Specialist
Specialist
Author

I have posted it ,But I dont know where,

Could I drop mail of it,

here how I attach file

arulsettu
Master III
Master III

click reply and then click use advanced editor then attach the files

tyagishaila
Specialist
Specialist
Author

I have attached,

Here If I choose single month at a time, I got correct result,

But If I choose jan and feb both than % distribute between two months.. so on..

Thanks for help

arulsettu
Master III
Master III

do you have data source in excel

tyagishaila
Specialist
Specialist
Author

no, it is in sql