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: 
alwinsch
Creator
Creator

PivotTable expressions with date

Hi all,

I want to create a Pivot Table, with expressions like <11/2016 ---- 11/2016 --- and 12/2016 as column headers

how can i create this, when i have the following fields:

paydate ( dd/mm/YYYY),

Amount

so i want the exact amount in the correct column when the date is correct.

Can the column headers be dynamic? when i call this report next month, the headers should look like the following:

<12/2016 --- 12/2016 --- 01/2017

thanks for your help.

Alwin

13 Replies
ganeshsvm
Creator II
Creator II

Yes Alwin, the solution wasn't dynamic at all, I was giving you an idea how you get the solution for your requirement.

and hope you have got the solution which you desired.

Regards,

Ganesh

ganeshsvm
Creator II
Creator II

One question on your query,

Iin the display "<11-2016", do you want to accumulate data for the previous months(from Jan to Oct) or just show sum of previous month(Oct) data?

alwinsch
Creator
Creator
Author

indeed, i want to accumulate everything before < 11-2016 - i called the column "earlier then"

ganeshsvm
Creator II
Creator II

Fine, That's what I assumed earlier also from your original post where you didn't mention it and also posted my solution accordingly.

Hope you have got your solutions.

Cheers .