topic Re: Dynamic Enable condition in Adhoc Reporting Qlikview in QlikView

Dynamic Enable condition in Adhoc Reporting Qlikview

bhavikumehta — Tue, 31 Jul 2018 11:10:05 GMT

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 ?

Re: Dynamic Enable condition in Adhoc Reporting Qlikview

sunny_talwar — Tue, 31 Jul 2018 11:22:34 GMT

Dynamic based on what? Can you elaborate?

Re: Dynamic Enable condition in Adhoc Reporting Qlikview

bhavikumehta — Tue, 31 Jul 2018 13:09:55 GMT

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

each dimension.

Hope this answers your question.

Regards,

Bhavik

+91-7387084384

'Get used to rejections, you'll be unstoppable'

Re: Dynamic Enable condition in Adhoc Reporting Qlikview

sunny_talwar — Tue, 31 Jul 2018 13:13:49 GMT

But you need to hard-code the value in this expression at least once, right?

=SubStringCount(concat(dim, '|'),'a')

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?