Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

FORMULA IN PIVOT TABLE

Hi guys,

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:

-1-10

  1-12

-1-20

  1-23

Can anybody help me with the formula?

Thanks!

2 Replies
isingh30
Contributor III

Re: FORMULA IN PIVOT TABLE

Please share your data or app.

Thank you!

wanyunyang
Contributor

Re: FORMULA IN PIVOT TABLE

My data as in my example. I'm trying to use the formula:

IF(saleswritten_date>=visit_date+7, DATE(saleswritten_date))

in my 3rd dimension(saleswritten_date dimension). But it doesn't work well.