Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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