topic Re: Find a value in qvd file in QlikView

Find a value in qvd file

Thu, 03 Oct 2013 21:38:54 GMT

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

Re: Find a value in qvd file

nicolett_yuri — Thu, 03 Oct 2013 21:47:09 GMT

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

Re: Find a value in qvd file

Thu, 03 Oct 2013 21:50:40 GMT

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.

Re: Re: Find a value in qvd file

nicolett_yuri — Thu, 03 Oct 2013 22:05:18 GMT

Look at this example

Re: Find a value in qvd file

Thu, 03 Oct 2013 22:12:14 GMT

HI Yuri

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

Re: Find a value in qvd file

nicolett_yuri — Thu, 03 Oct 2013 22:23:06 GMT

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