Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I got a straight table with an Id as dimension. When a certain checkbox is selected, any row of this table should only be shown when 'total' for that row is greater than zero. The expression for this column is:
=count(FaultId)
ex.
id | Value | total |
---|---|---|
id001 | someValue0 | 0 |
id002 | someValue1 | 0 |
id003 | someValue2 | 2 |
id004 | someValue3 | 4 |
In this case the table should look like this when the checkbox is selected:
id | Value | total |
---|---|---|
id003 | someValue2 | 2 |
id004 | someValue3 | 4 |
How do I achieve this?
Regards,
Sijmen
Thank you for your response, I will try that for now.
But yes, I need this option to be selectable. I'm still a beginner at Qlikview, but do you have any pointers on how to achieve this?
I had something like this in mind:
For the other columns to be set to zero, two conditions have two be met:
1. total = 0
2. vHideColumns = 1
Then some clickable object changes the variable vHideColumns from 1 to 0 when clicked, and from 0 to 1 when clicked again.
Could this work?
EDIT: It works! I used a button sheet object like this:
New Sheet Object -> Button - actions -> Set Variable -> vHideColumns 0
Then create another button to restore it back to 1
Problem solved, thanks for the help.
Regards,
Sijmen
Right Click then Properties --> Presentation tab and then check the suppress zero-values
That is already checked for every expression. Also, the ids are never zero. This does not work.
Suppress Zero hides only the rows where all expressions are 0 (it's chart-level, not expression-level). You have something other than 0 in Value column, so nothing gets hidden.You could change the expression for Value column, so it shows something other than 0/null only when there is something other than 0 in the total column:
=If([total], [whatever the expression was before])
and then Suppress Zero should work.
If you want to have an actual user-selectable checkbox instead of changing chart properties, that's a bit more complicated.
Thank you for your response, I will try that for now.
But yes, I need this option to be selectable. I'm still a beginner at Qlikview, but do you have any pointers on how to achieve this?
I had something like this in mind:
For the other columns to be set to zero, two conditions have two be met:
1. total = 0
2. vHideColumns = 1
Then some clickable object changes the variable vHideColumns from 1 to 0 when clicked, and from 0 to 1 when clicked again.
Could this work?
EDIT: It works! I used a button sheet object like this:
New Sheet Object -> Button - actions -> Set Variable -> vHideColumns 0
Then create another button to restore it back to 1
Problem solved, thanks for the help.
Regards,
Sijmen
presentation tab u will have in down
I think it should work all right and that's how I would approach it myself I have implemented single checkboxes before as text objects with wingdings for empty and filled checkbox (which was shown at the moment was changed according to the current value of the variable being changed), maybe you'll find this approach useful.