Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Dividing a dimension in pivot table

Hi guys,

I created a pivot table in Qlik Sense like this.

There is a sales quote table recording customer_No and sales quote date, and a visit table recording customer_No and visit date. The tables are connected by customer_No. This is a record of a sales rep with 2 visit dates(01-12,01-15) and 3 sales quote dates(01-12,01-15,01-16) in total. The bolded dates are the visit dates, the unbolded are the sales quote dates.

Capture.PNG

Now I want to put sales quote date 01-12 under visit dates 01-12, sales quote date 01-15 and 01-16 under visit dates 01-15. The result should be like this:


-2018-01-12

2018-01-12

-2018-01-15

2018-01-15

2018-01-16

Is it possible to do that? Thanks for help!

0 Replies