Discussion Board for collaboration related to QlikView App Development.
I have a Adhoc report with 70 dimensions and 10 measures using Table chart
Is there a way we can make dimension measure show/hide in Table chart dynamic based on user selection?
Normal scenario - if user selects dim A, Table will show dim A when we write 'Enable condition' for dim A as something like "=SubStringCount(concat(dim, '|'),'a')"
Expected scenario - there should not be a need to hardcode 'a' in 'Enable condition' - Can we make that dynamic ?
Dynamic based on what? Can you elaborate?
Dynamic in the sense common 'Enable condition' for all the dimensions (by
using, for instance, variables) still only user selected dimensions show up
in the Adhoc report.
For example -
Dimensions: A, B, C, D
User selected: A, C
Enable Condition for all the dimenions can be the same by making use of
variables or some in-built functions, instead of hard coding separately for
Hope this answers your question.
'Get used to rejections, you'll be unstoppable'
But you need to hard-code the value in this expression at least once, right?
Without hard-coding this even once, I do you expect QlikView to know what is the condition on which you need to show a particular dimension?