Find a value in qvd file

[#1]

Hi guys,

I need to find a value in a field of a QVD file.

What could be the best way to do it?

I can load the qvd file in resident table and do a for loop and do match but it seems very elementary approach.

Regards

Saurabh

[nicolett_yuri]

Can provide more details of your question? There are several functions and logical to locate something

[#3]

Hi Yuri,

I have a QVD file with 3 fields and I want to search in one of those fields for a particular value. I need to use different logic depending on existence of this value in that field.

[nicolett_yuri]

Look at this example

[#5]

HI Yuri

I am not able to this file. QlikView is giving warning because it is created by another personal edition of Qlikview.

[nicolett_yuri · Accepted solution]

I created some examples for you

Tabela1:

LOAD * INLINE [

Dimensao, Valor1, Valor2

A, 2 , 20

B,2,1

A,3,300

C,1,5

D,7,3

E,5,1

F,3,1

];

sum if the 'Dimensao' is equal to "A"

SUM(if( Dimensao = 'A', Valor1)) + SUM(if( Dimensao = 'D', Valor2))

sum if the 'Dimensao' is equal to "A" or "B" or "C"

SUM(if( WILDMATCH( Dimensao, 'A', 'B', 'C')>0, Valor2))

sum if the 'Dimensao' is not equal to "A" or "B" or "C"

SUM(if( WILDMATCH( Dimensao, 'A', 'B', 'C')=0, Valor2))