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

How do you filter the data you want to charge in Qlik??

Hi,

I have the following in my initial script,

LOAD Año,

Mes,

Materiale,

[Qtà stk. val.],

[Valore stk. v.]

FROM

(ooxml, embedded labels, table is [Inventario mes]);

My intention is to charge only the Data that stisfies an expression such as:

[([Qtà stk. val.]!=0) & ([Valore stk. v.]!=0)]

How should i change the script to make Qlikview load ONLY the Data that satisfy the expression??

Thanks a lot for your time!!!!!!!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Are you sure your 0 is stored as a zero?

Try this:

WHERE FABS([Qtà stk. val.]) < 0.001 AND FABS([Valore stk. v.]) < 0.001

View solution in original post

8 Replies
Anonymous
Not applicable
Author

I think this is what you are after.

LOAD Año,

Mes,

Materiale,

[Qtà stk. val.],

[Valore stk. v.]

FROM

(ooxml, embedded labels, table is [Inventario mes])

WHERE [Qtà stk. val.]<> 0 AND [Valore stk. v.] <> 0;

Not applicable
Author

Hi,

The script still shows me lines where:

[Qtà stk. val.]



<> 0 AND [Valore stk. v.] <> 0

I think the problem is that this fields are loaded from few Monthly inventary files. I imagine the script looks if the total sum of [Valore stk. v.] & [Qtà stk. val.] is zero for all the months.

I would like to charge only the lines that satisfy the condition for every month, indiferently if the last month it's been or not satisfied.

Hope you understood me!!

Thanks again!!!!

vgutkovsky
Master II
Master II

Alberto,

The solution in the previous post should work for you. This does not aggregate, but will rather look at the row-level data and take all rows that satisfy the expression.

Regards,

Not applicable
Author

Hi!

I've tried the script you told me:

After running it, a object in my Inventory still shows me values for codes that satisfy the expression:

And i checked the values for the March file and is correct:

I think the object shouldn't show that Materiale on the march inventory. Also it affects other objects. Does someone know where the problem might be??

THANKS!!!!

Anonymous
Not applicable
Author

Are you sure your 0 is stored as a zero?

Try this:

WHERE FABS([Qtà stk. val.]) < 0.001 AND FABS([Valore stk. v.]) < 0.001

Not applicable
Author

I've tried with your way, and Qlikview shows me only the values with 0 & 0:

WHERE FABS([Qtà stk. val.]) < 0.001 AND FABS([Valore stk. v.]) < 0.001

To obtain what i really want i changed the expression to :

WHERE FABS([Qtà stk. val.]) > 0.001 AND FABS([Valore stk. v.]) > 0.001

Now it shows me all the values, zeros and != zero, as if the expression wasn't there!!! Incredible....

I don't have a clue about where the problem might be...

vgutkovsky
Master II
Master II

Well, hold on a second. You've introduced a new dimension to your chart that wasn't in your main table that you posted. I'm assuming this dimension is in another table that is linked to the first table on "Materiale." So if your "Nombre Materiale" table lists a "Materiale" that does not exist in your first table, the sum of your metrics will be zero. This is not because you have 0-value records in the first table, but because there is no matching Materiale. Make sense?

Regards,

Not applicable
Author

It makes plenty sense now!!

Thanks a lot!!