topic Re: Show N records in pivot table in QlikView

Show N records in pivot table

Fri, 10 Apr 2015 12:24:52 GMT

Hello,

I would like to know how to show for example 3 records in a table based on a value selected in a filter.

For example if i select a month/year 01/2014 i would like to display in pivot table records for 01/2014, 02/2014 and 03/2014.

Thank you very much for your answer,

Regards,

P.L.

Anonymous — Fri, 10 Apr 2015 15:32:37 GMT

Would you be able to attache some sample data?

Thanks,

Fri, 10 Apr 2015 16:44:51 GMT

Hello Sir,

Thank you for your quick answer.

In attach to my first post, a brief example of what i want. (example with month April)

Thank you,

Regards

Anonymous — Fri, 10 Apr 2015 17:35:48 GMT

Check the attached file. see if it helps.

ramoncova06 — Fri, 10 Apr 2015 21:17:22 GMT

they are couple of options to achieve this

thanks

Sat, 11 Apr 2015 00:20:11 GMT

Hi,

I calculated next_month in script and used in the expression:

sum({<month=, number={">=$(=Only(number))<=$(=Only(next_number))"}>} Value)

Sat, 11 Apr 2015 12:29:16 GMT

Hello Amarbogam,

Thanks again for your prompt reply.

This perfectly meets my need.

Thanks a lot,

Regrads

Sat, 11 Apr 2015 12:35:15 GMT

Hello Ersen,

This also works great for me...

Thanks a lot for your help,

Regards,