topic Help in row selection in QlikView

Help in row selection

pradosh_thakur — Tue, 07 Nov 2017 06:59:33 GMT

Please find the attached qvw.

It has a pivot table. I need to select 1,3,5,10,15,20 rows of corresponding item and show the in below format. A pivot or straight table will do.

regards

Pradosh

prma7799 — Tue, 07 Nov 2017 07:10:45 GMT

Have you tried "If(Match(ID, 1, 3, 10, 15, 20),ID,Null())" for calculated dimension in Pivot table?

Sergey_Shuklin — Tue, 07 Nov 2017 07:15:09 GMT

Hello!

Please, look at the picture below and the attachement. Is this the goal?

pradosh_thakur — Tue, 07 Nov 2017 07:16:30 GMT

I want the row no not the ID. and you can see there is no id in the output.

regards

Pradosh

pradosh_thakur — Tue, 07 Nov 2017 07:19:54 GMT

Hi Sergey

looks promising buddy. Let me Apply that in my app and will get back.

Thank you.

regards

Pradosh

pradosh_thakur — Tue, 07 Nov 2017 09:55:45 GMT

Hi Sergey

The sorting seems create some problem. i need the sum to be in descending order first then sort the row.

regards

Pradosh

Sergey_Shuklin — Tue, 07 Nov 2017 10:26:05 GMT

Hello!

If you are using QV12 you can solve this with sort condition of the second parameter of Aggr() function:

There are some curved red lines - don't pay attention on them.