Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Pivot Table header expand

Hello There,

What my concern is how to use pivot table base on report i try to use it but I'm failed, i need to count all Agreement ID base on Trans_Date and this is what i did:  =num(count({$<[Agreement ID]= {'*'}, Tran_Date=>} [Agreement ID] )) i got 94 )which is correct then i need to count (DPD)= {91} base on  MonthYear and  [Agreement ID] that was connected at  Agreement ID into sales sheet count all Agreement ID in as of date that match in Agreement ID at sales sheet i have attached file for my sample data source.

relation.png

 

 

 

The goal is to display the Trans_Date and total count of Agreement Id in Sales Sheet and expand as of date in header below is the output of what i need.

 MonthYearMay,2015Jun,2019
Tran_DateTotal Count  
Jan,2015942017

also in as of sheet counting the Agreement ID happen just once, sample if this Agreement Id =133414 already count in a month of May,2015 and also this Agreement ID is existing in month of Jun,2015 no need to count.

Thank you for your help,

Best regards,

Bing

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Pivot Table header expand

Modified some of your scripts and front end expressions:

MC.PNG

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Pivot Table header expand

Can you attach a sample qvw?

Highlighted
Contributor

Re: Pivot Table header expand

Hello Arthur,

 

Attached file is my sample qvw.

 

Best Regards,

Bing

Highlighted
Partner
Partner

Re: Pivot Table header expand

Modified some of your scripts and front end expressions:

MC.PNG

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

View solution in original post

Highlighted
Contributor

Re: Pivot Table header expand

Thank you so much very helpful, great support highly appreciated.

Note: additional question  if ever i want to Count (DPD) > {'100'})[Agreement ID]) how can i do that?

 

Best Regards,

Bing

Highlighted
Partner
Partner

Re: Pivot Table header expand

count(if ( DPD>100, [Agreement ID]))