Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
paulyeo11
Valued Contributor III

How to add Total Exp Amount contribution % for my pivot table ?

Hi All

My pivot table Expression as below :-

(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

     }

     , month = ,year=>}[Amount])/1000)

I like to compute the total sales contribution % , I aware i need to  like some thing like below :-

(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

     }

     , month = ,year=>}[Amount])/1000)

/

(

Sum(TOTAL({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

999"

     }

     , month = ,year=>}[Amount])/1000)

)

But it does not work , hope some one can advise me.

Paul

1 Reply
Highlighted
paulyeo11
Valued Contributor III

Re: How to add Total Exp Amount contribution % for my pivot table ?

My QV Doc