Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
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
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?
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
HI
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
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
Hi
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
Thank you very much! Your expression is exactly what I needed!!!!!
Eduardo