Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.