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]

You forgot the attachment????

[#3]

attached to main post. buddy    

[avinashelite]

Hi Sampath,

I got your problem, as per my knowledge 2 expression cannot be shown  one below the other in Pivot table!!

it will show in the format what i have attached, we can get similar representation using straight table by selecting Horizontal in the presentation.

If you want achieve that representation, from the sql query calculate the sum of QTY and use that as a dimension and make min of QTY as expression. 

Please find the attachment.

[Raj11]

Hi,

will this chart suits your req.

Thanks,

Niranjan M