Min of expression in pivot table

[#1]

Hi Qlikers,

i have pivot table with two dimensions as name and date, i have expression then i have dragged the date above the expression so the chart will become (Please find the attachment).

i want another expression in same table which should display min of the above expression for all the dates.

Please find the attached QVW.

Thanks& Regards

Sampth Botla

[avinashelite]

Hi Sampath,

Please post your qvw file with sample data.

[Anonymous]

Hi,

I am not sure if I understand correctly but below script may help you.

Expression 1 = Sum (Sales)

Expression 2 = Min(Aggr(Sum (Sales), Buyer, Date))

[SunilChauhan]

aggr(Min(Your expression here),DateField)

DateField---->in image  19 May,21 May etc

hope this helops

[#5]

Please Find the Attached QVW to original post.

[SunilChauhan]

in place of Date in dimension

use

=Date(aggr(Min(ExecDate),Name),'DD-MMM')

and leave Expression  as Sum(Qty)

hope this helps

[avinashelite]

Hi Sampath,

To add clarity i have add few more data.

Please find the attachment for solution, hope this is what ur looking for.

[#8]

i want pivot table with name on left side and exec date at the top and i want expression is sum(qty), i want to display min(sum(qty)) to all the dates in another expression.

[avinashelite]

can you please share me the format.

[#10]

Please find the attached QVW file.