Pivot table

[#1]

Hi qlikers,

i have date (slider) and a pivot table with some stock data.

when i select some dates in slider for example from 10-jan to 15-jan

in pivot table we have data only from 10-jan to 12-jan ,

then i want to take min and max of date with respect to pivot table data.

then i want to find the

(stock(mindate)-stock(maxDate))/stock(mindate)

Thanks in advance.

Sampath Botla

[Gysbert_Wassenaar]

If the pivot table doesn't show some dates, then there is probably no data for those dates. Perhaps you can post an example document with some data and an explanation of what you're trying to do.

[Raj11]

Hi,

Try this expression in Pivot Table

=sum({<date = {"$(=min(Date))"}> Stock} - sum({<date = {"$(=max(Date))"}> Stock}/sum({<date = {"$(=min(Date))"}> Stock}

Thanks,

Niranjan M.