topic Pivot table in QlikView

Pivot table

Thu, 26 Jun 2014 09:19:22 GMT

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

Re: Pivot table

Gysbert_Wassenaar — Thu, 26 Jun 2014 09:28:45 GMT

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.

Re: Pivot table

Raj11 — Thu, 26 Jun 2014 09:33:24 GMT

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.