Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pradosh_thakur
Master II
Master II

Help in row selection

hi

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.

Capture.PNG

regards

Pradosh

Learning never stops.
1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hello!

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

rows2.png

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

View solution in original post

6 Replies
prma7799
Master III
Master III

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

Sergey_Shuklin
Specialist
Specialist

Hello!

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

rows.png

pradosh_thakur
Master II
Master II
Author

Hi

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

regards

Pradosh

Learning never stops.
pradosh_thakur
Master II
Master II
Author

Hi Sergey

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

Thank you.

regards

Pradosh

Learning never stops.
pradosh_thakur
Master II
Master II
Author

Hi Sergey

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

regards

Pradosh

Learning never stops.
Sergey_Shuklin
Specialist
Specialist

Hello!

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

rows2.png

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