find out a specific data in a .csv format file source

[roger0802]

hi,

my file in qlikview take the data by many .csv files, created by my payroll program.. in one of these files there is a column named "amount", in the other one a column named "month"

I'd like to find out the amount of february, for example..

month     amount

1               1000

2               1000

3               1100

4               1100

5               1100

6               1200

7               1100

8               1150

9               1250

10              1300

for example, I nedd the amount of august, so 1150

I don't know if it's the right way, but I've tried many functions (Last, MaxString, Get etc..) and they don't work

thank you very much

Ruggero

[roger0802]

in the Italian version (I think..) of QlikView there are no curly brackets and quotes ..     <}

may mean something?

[Clever_Anjos · Accepted solution]

You should use these caracters, because they´re part of Set Analysis syntax

You have renamed the fields, so you must use the new names

=sum({<[MESE_CEDOLINO_DESCRITTIVO] = {"Ago"}>} [paga di fatto])

[roger0802]

there's alway Error in expression..

[roger0802]

I don't know how to thank you for your time..

[Clever_Anjos]

Weird,

Could you post your qvw?

Or just send it by email to clever@clever.com.br

[roger0802]

you mean send you only the .qvw file? or the .csv files, too?

tomorrow morning I'll send you by mail..

thank you

[Clever_Anjos]

qvw is enough

[Clever_Anjos]

I´ve sent to your email