Difference between dates in Pivot Table

[ShahbazovT]

Hello,

I am new in Qlik sense and I have a many problems 🙂

I have here a pivot table and want to have another column reflecting the difference between "Sep-20" and "Oct-20" dates. They are located in the same column, named by Date (Date expression - =(Date(monthstart(TRN_DT), 'MMM-YY')))

Please help 🙏

 

[brunobertels]

Hi 

in a cross table you can use before function like this 

sum(sales)-before(sum(sales)) 

or use the column function like this 

Column(1)-before(Column(1))

[ShahbazovT]

Thank you for support.

There are some dates,  and i want to find between only two dates, "30-09-20" and "31-10-20"

 

[brunobertels]

Hi 

in a filterpan if you want to select periode do like this 

use > or >= 30.09.2020 <=31.10.2020

[ShahbazovT]

Help pls🙏

[ShahbazovT]

It didn't help me
thank you very much again

[Chanty4u]

Have a look here it will help

https://community.qlik.com/t5/New-to-QlikView/Listbox-Date-search-string-problem/m-p/662460

https://community.qlik.com/t5/New-to-QlikView/How-to-select-a-range-of-dates-from-list-box/td-p/4758...

[ShahbazovT]

It didn't help too

thank you