topic order by month year and activity in QlikView

order by month year and activity

fkeuroglian — Tue, 24 Nov 2015 01:58:47 GMT

Hi expert i have this qvd i want to order by month year and activity

see the attached image that i have now in my qvd.

i want to create a sort like this in the script:

01-2011 FreeShop

02-2011 FreeShop

03-2011 FreeShop

04-2011 FreeShop

05-2011 FreeShop

06-2011 FreeShop

07-2011 FreeShop

08-2011 FreeShop

09-2011 FreeShop

10-2011 FreeShop

11-2011 FreeShop

12-2011 FreeShop

01-2011 Retail

02-2011 Retail

03-2011 Retail

04-2011 Retail

05-2011 Retail

06-2011 Retail

07-2011 Retail

08-2011 Retail

09-2011 Retail

10-2011 Retail

11-2011 Retail

12-2011 Retail

I have 4 differentes activityies and i want to create and order MONTHYEAR and then Activity

i try to put order by MonthYear, Activity but my order is like the image attached

i attached the .qvd

thank for any helps

Fernando K.

Re: order by month year and activity

tamilarasu — Tue, 24 Nov 2015 02:32:32 GMT

Hi Fernando,

Check the attachment !.

Re: order by month year and activity

fkeuroglian — Tue, 24 Nov 2015 11:04:09 GMT

Thank you Tamil!

works great

Fernando K.

Re: order by month year and activity

tamilarasu — Tue, 24 Nov 2015 11:47:31 GMT

You are welcome Fernando.

Re: order by month year and activity

fkeuroglian — Tue, 24 Nov 2015 13:47:26 GMT

Hi Tamil,may be you have the solution to this! thanks a lot

I want to use the peek function to acumulutae values in the script, and if i do not have value to one month, take the acumuluate and create a value that bring the previous (peek) value that i have in the table

for example

Retail 01-2010 100

Retail 02-2010 0

Retail 03-2010 50

Bank 01-2010 140

Bank 02-2010 0

I want something like this

Retail 01-2010 100

Retail 02-2010 100

Retail 03-2010 150

Bank 01-2010 140

Bank 02-2010 140

i attached and image that i have result and the qvd is simple only few register and field

i am using the peek, but i am sure i have an errror

thank you a lot

Fernando K.

Re: order by month year and activity

tamilarasu — Tue, 24 Nov 2015 14:26:27 GMT

Hi Fernando,

I am not near to my system. Anyhow, you can try something like below

If(rowno()=1,Sales,

If(Peek(Type)=Type and Peek(Year(DateField))=Year(DateField), Peek(Sales)+Sales)) as TotalSum

Replace the column name sales to your desired column.

Give a try and let me know.