Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
wanass123
Contributor II
Contributor II

Add Months in table - please help

Hello everyone , 

I have data in the below table : 

Amount Paid  PaymentDate
322 9-Aug-22
131 2-Sep-22
212 2-Oct-22
200 20-Aug-22
113 8-Aug-22

 

and I need to extend the table and  add Month when payment was done example : 

Amount Paid  PaymentDate October September August
322 9-Aug-22     322
131 2-Sep-22   131  
212 2-Oct-22 212    
200 20-Aug-22     200
113 8-Aug-22     113

 

please help 

Labels (1)
1 Solution

Accepted Solutions
OmarBenSalem

load
AmountPaid,
date(date#(PaymentDate,'D-MMM-YY')) as PaymentDate,
Month(date#(PaymentDate,'D-MMM-YY')) as PaymentMonth
Inline [
AmountPaid, PaymentDate
322, 9-Aug-22
131, 2-Sep-22
212, 2-Oct-22
200, 20-Aug-22
113, 8-Aug-22

 

Create a pivot table : 

Lines : AmountPaid, PaymentDate

Column : PaymentMonth

Measure: sum(AmountPaid)

];

OmarBenSalem_1-1665579984308.png

uncheck this in the presentation :

OmarBenSalem_2-1665580013519.png

 

View solution in original post

1 Reply
OmarBenSalem

load
AmountPaid,
date(date#(PaymentDate,'D-MMM-YY')) as PaymentDate,
Month(date#(PaymentDate,'D-MMM-YY')) as PaymentMonth
Inline [
AmountPaid, PaymentDate
322, 9-Aug-22
131, 2-Sep-22
212, 2-Oct-22
200, 20-Aug-22
113, 8-Aug-22

 

Create a pivot table : 

Lines : AmountPaid, PaymentDate

Column : PaymentMonth

Measure: sum(AmountPaid)

];

OmarBenSalem_1-1665579984308.png

uncheck this in the presentation :

OmarBenSalem_2-1665580013519.png