# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for
Search instead for
Did you mean: Not applicable

## Find a value in qvd file

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

1 Solution

Accepted Solutions  MVP

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))

5 Replies  MVP

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

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.  MVP

Look at this example Not applicable
Author

HI Yuri

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

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)) 