Discussion board where members can get started with Qlik Sense.
I have a raw data table with columns: customer, visit_date, saleswritten_date. Now I want to create a pivot table and put these three columns as three dimensions.
For saleswritten_date, I'm trying to show only those dates not within 7 days of visit_date. For example, for a certain customer:
visit_date 1-10, 1-20
sales_date 1-12,1-18, 1-23, 1-30
Then the result should be like:
Can anybody help me with the formula?
Please share your data or app.
My data as in my example. I'm trying to use the formula:
in my 3rd dimension(saleswritten_date dimension). But it doesn't work well.