How to use the values in same field multiple times in one expression?

[#1]

Hi

I have a field with ($) values connected to a second field with the descriptions. Ie descriptions can be income, taxes, rent, funding.

All data are connected to specific individuals (PersonID)

How can I do expression with  PersonId as dimension and how much funding the have. But only for people that have a income < 5000 and rent > 2000?

My problem is that the $-values are all in the same field and I don´t want to create individual fieldvalues for rent, income, funding in the script.

I´m Think I have to use the concat functions some how but can´t get it work.

Any suggestions?

Edit:

Attached a sample data

Id / person 28  income of 9014, a rent 5808 and funding of 3320.

Id / person 1089 income of 12988, rent 5406 and funding 191

Id / person 1790 income of 7564, no funding (null- value) and rent 4098

By the 3 person I want a expression that shows the two latest by the criteria income > 5000, funding < 1000 and rent > 2000

Sorry for not uploaded a sample at the first post. And a bit changed criteria, it´s only a example.

Thanks for all feedback and help!

[IAMDV]

Hi,

Glad to know that but remember Generic load will create separate fields for each distinct field value, it's opposite to the Crosstable prefix. Eitherway, please let us know if you have a solution and also close the thread if yes. If not, one of us will help you.

Cheers,

DV

www.QlikShare.com

[#3]

As mentioned it's not the best solution, multiple field, bigger datamodel but I thought it was the only solution because it was the only thing that were suggested. Is there a way to solve it and keep the values in same field, ie by any set expression or other way I would love to know!