Qlik Community

Ask a Question

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
nicolett_yuri

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

View solution in original post

5 Replies
nicolett_yuri

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.

nicolett_yuri

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.

nicolett_yuri

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

View solution in original post