topic Re: Load rows over a specific value in QlikView

Load rows over a specific value

Wed, 02 Jan 2013 16:23:31 GMT

Hi,

in the attached file I would like to download only the rows which its 'SEGMENTO02' or 'CTA' are bigger than 5999, I tried with LOAD...WHERE but maybe CTA are not numbers or something i'm not able to load only the rows with CTA>5999.

Thanks in advance.

Re: Load rows over a specific value

Wed, 02 Jan 2013 16:52:05 GMT

Dear lmenendez,

you need to write the where condition like

in first table you need to write the where condition

Where SEGMENTO02>5999

and in second table

Where CTA>5999

i attached the qvw with the modification.

kindly find the attachement.

i hope it will help you.

Thanks,

Mukram.

Re: Load rows over a specific value

Wed, 02 Jan 2013 17:00:09 GMT

Thank you very much, I was spelling wrong.