topic Re: Min of expression in pivot table in QlikView

Min of expression in pivot table

Thu, 10 Jul 2014 05:49:52 GMT

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

Re: Min of expression in pivot table

avinashelite — Thu, 10 Jul 2014 05:58:39 GMT

Hi Sampath,

Please post your qvw file with sample data.

Re: Min of expression in pivot table

Anonymous — Thu, 10 Jul 2014 06:05:51 GMT

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))

Re: Min of expression in pivot table

SunilChauhan — Thu, 10 Jul 2014 06:07:30 GMT

aggr(Min(Your expression here),DateField)

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

hope this helops

Re: Min of expression in pivot table

Thu, 10 Jul 2014 06:14:30 GMT

Please Find the Attached QVW to original post.

Re: Re: Min of expression in pivot table

SunilChauhan — Thu, 10 Jul 2014 06:31:37 GMT

in place of Date in dimension

use

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

and leave Expression as Sum(Qty)

hope this helps

Re: Min of expression in pivot table

avinashelite — Thu, 10 Jul 2014 06:36:19 GMT

Hi Sampath,

To add clarity i have add few more data.

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

Re: Min of expression in pivot table

Thu, 10 Jul 2014 06:39:49 GMT

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.

Re: Min of expression in pivot table

avinashelite — Thu, 10 Jul 2014 06:49:54 GMT

can you please share me the format.

Re: Min of expression in pivot table

Thu, 10 Jul 2014 06:57:29 GMT

Please find the attached QVW file.

Re: Min of expression in pivot table

avinashelite — Thu, 10 Jul 2014 07:01:30 GMT

You forgot the attachment????

Re: Min of expression in pivot table

Thu, 10 Jul 2014 07:06:57 GMT

attached to main post. buddy

Re: Re: Min of expression in pivot table

avinashelite — Thu, 10 Jul 2014 07:30:24 GMT

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.

Re: Min of expression in pivot table

Raj11 — Thu, 10 Jul 2014 09:56:17 GMT

Hi,

will this chart suits your req.

Thanks,

Niranjan M