Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load rows over a specific value

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

2 Replies
Not applicable
Author

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.

Not applicable
Author

Thank you very much, I was spelling wrong.