topic Re: Data filter in QlikView

Data filter

Thu, 25 Oct 2012 14:33:10 GMT

Hey,

I need some help with Qlikview. I have uploaded 5 columns, the first one with the date and the others with numbers. Then with these data I plot 3 charts. In 2 of these 3 charts I would like to filter the data, because sometimes I have 0's or numbers above 1, what doesn't make sense for these 2 charts. How can I "delete" these rows of data in these 2 charts???

Thank you very much for your help!!!!!

Eduardo

Re: Data filter

Gysbert_Wassenaar — Thu, 25 Oct 2012 14:48:44 GMT

You can use calculated dimensions to make a 'new' dimension that only shows the data you want. Depending on your situation it may also be possible to fix the issue with a set analysis expression in the charts expressions. Can you share the qvw you're working on and telling us what you need in more detail?

Re: Data filter

Thu, 25 Oct 2012 14:56:35 GMT

Hey Gysbert!

My Data looks like this (but with many more rows):

Datum	Z1V1niO	Z1V2niO	Z4V1niO	Z4V2niO
03.08.2012 13:14	0,453	0,18	0,178	0,434
03.08.2012 13:23	0,48	0,193	0,17	0,436
03.08.2012 13:49	0,445	0,183	0,175	0,442
03.08.2012 14:19	0	0	0	0
03.08.2012 14:21	0,451	0,182	0,171	0,471
03.08.2012 14:31	0,499	0,189	0,192	0,473
03.08.2012 15:08	0,429	0,178	0,158	0,456

I would like not to take into account for example the lrow with only 0's (4th line).

The chart in which I want to "delete"/"not take into account" these rows has as dimensions "month" and "day". Has formula I have "Avg(Z1V1niO)"; "Avg(Z1V2niO)"; etc.

How can I use a "set anaysis"?? I tried to learn how it works but I didn't find proper documentation....

Thank you very much for your help!!!

Eduardo

Re: Data filter

MayilVahanan — Thu, 25 Oct 2012 14:59:53 GMT

Try like this

=if(Avg(FieldName) > 0, Avg(FieldName))

Tick suppress missing value, suppress zero value in presentation tab

Tick suppress when value is null in dimension tab..

Hope it helps

Re: Data filter

Fri, 26 Oct 2012 06:35:25 GMT

Thank you for your help! I appreciate it. But I don't thnik that this expression is exactly qhat I am looking for. As "Dimensions" I have "Day" so IF(AVG(FIELDNAME)>0,...) is checking the average of the entire day, not the value in each row...

Thank you again and please help me understand how Qlikview works!

Eduardo

Re: Data filter

MayilVahanan — Fri, 26 Oct 2012 17:07:08 GMT

Avg(Z1V1niO) calculates the average of Z1V1niO.

avg({<Z1V1niO={'>0'}>}Z1V1niO) checks the Z1V1niO value is greater than zero, and calculate the average of Z1V1niO

=if(Avg(Z1V1niO ) > 0, Avg(Z1V1niO )) checks Avg(Z1V1niO ) is greater than zero, if it satisfy means, calculate the avg(Z1V1niO ) value..

Hope it helps

Re: Data filter

Mon, 29 Oct 2012 12:53:57 GMT

Thank you very much! Your expression is exactly what I needed!!!!!

Eduardo