Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grabbing data from different rows

Hi,

I have attached data and qvw file. My requirement is I want to get the data like this.

Ex:

Name                          Rate        Gross

ARNOLD, OLIVIA        10.70        841.17

I am able to implement First two columns Name, Rate but not able to pick the GROSS.

I am doubt that whether it is possible or not by using Qlikview. I am trying out using function in excel too. But no success.

Pls let me know if any one have come across the scenario. I am using Qlikview Personal edition.

Thanks,

2 Replies
its_anandrjs
Champion III
Champion III

Check your Gross column is empty.

Not applicable
Author

No probs, but it is taking by default some field name right.