topic Re: aggrgate below fields in QlikView

aggrgate below fields

Anonymous — Wed, 10 Jul 2013 15:11:24 GMT

Hi ,

I'm trying to get YTD in reverse order

here are my monthly values

sep - 200

oct - 210

nov - 300

dec- 400

jan - 100

feb - 200

mar- 230

and expected output should be

sep - 1540

oct - 1340

nov - 1130

dec- 830

etc

how to write the script logic for thislogic in script () and not in the front end chart calculation

i also need to do group by with certain filter fields

Any suggestions

Re: aggrgate below fields

jagan — Wed, 10 Jul 2013 15:42:37 GMT

Hi Srikanth,

Post sample data with all the fields. so that it would be useful to analyse and give solution.

Regards,

Jagan.

Re: aggrgate below fields

Anonymous — Wed, 10 Jul 2013 15:52:38 GMT

Hi Jagan,

Thanks for the reply . Please find the attached ....

I need cumulative to be calculated in reverse order .......

Re: aggrgate below fields

jagan — Wed, 10 Jul 2013 16:03:56 GMT

Hi,

Please find attachment.

Regards,

Jagan.

Re: aggrgate below fields

RedSky001 — Wed, 10 Jul 2013 16:13:40 GMT

A slight variation on what Jagan came up with. Depends if you want to group by Product Category or not really.

Re: aggrgate below fields

Anonymous — Wed, 10 Jul 2013 16:23:26 GMT

Thanks Jagan and mark

both solutions works

really appricate your help guys

Re: aggrgate below fields

Anonymous — Wed, 10 Jul 2013 18:55:20 GMT

Hey Mark/Jagan,

I want to group it by one more Dimesion....this is what i'm using ......

if (rowno() =1,Cost,

if(Previous(Product) <> Product,Cost,if(Previous(subcategory) <> subcategory,Cost,Cost+Peek(rollingCost)))) as rollingtCost

it's not showing the correct value

I want to group to by product and subcategory

Any suggestions

Any suggestion

Re: aggrgate below fields

RedSky001 — Thu, 11 Jul 2013 08:34:49 GMT

load *

,if(rowno()=1,cost,if(Previous([Product Category]) <> [Product Category] or Previous([Sub Catergory]) <> [Sub Catergory],cost, Peek(Rollingcost)+cost)) AS Rollingcost

Resident Temp

Order by [Product Category],[Sub Catergory], Date desc

;