Adhoc Report - Enable condition

[priyarane]

Hi Community,

Enable conditonal is not working for Dimension and expression and same expression is working on other reports.

Enable condition expression:

Ex:

SubStringCount(Concat(%Dimension,'|'),'ACCOUNT_DEAL_ID')

[sunny_talwar]

May be try this:

=SubStringCount(Concat(DISTINCT %Dimension,'|'), 'ACCOUNT_DEAL_ID') = 1

[priyarane · Accepted solution]

Hi Sunny,

Thanks for your reply, its not working with your expression but below one is working

GetSelectedCount(%Dimension)>0 and SubStringCount(Concat(%Dimension,'|'),'ACCOUNT_DEAL_ID')

[sunny_talwar]

Not a problem

I am glad you got it resolved.

Best,

Sunny

[LCardonne]

Hi Sunny,

I'm writing to you because I have seen you reply on those topics and I could definitely use some advice!

I'm doing the same thing in an app:

SET HidePrefix='_';

AdhocDimensions:
LOAD * INLINE [_dimensionId, _dimension
A, CostCenter
B, NatureOfExpense
C, GroupingCode
D, ExpenseCategory
E, ExpenseId
];

I have a pivot table and I want to enable/disable dimensions.

For example, for dimension NatureOfExpense, I check "enable conditinal" and I have tried the following as enabling condition:

=SubStringCount(Concat(_dimensionId,'|'), 'B')

=SubStringCount(Concat(_dimension,'|'), 'NatureOfExpense')

=SubStringCount(Concat(_dimensionId,'|'), 'B')=1

=SubStringCount(Concat(_dimension,'|'), 'NatureOfExpense')=1

All of these works great on my PC in dev but when I deploy the documents on the QlikView Server and try the app in my browser: it does not work!

Would you have any clue why?

I have duplicated the app and tried another way:

I have an integer variable v_ShowHide that takes only 0 and 1 as value, this value is changed by a button.

On the dimension NatureOfExpense, I check "enable conditinal" and I have tried the following as enabling condition: 

v_ShowHide=1

$(v_ShowHide)=1

=if(v_ShowHide=1, 1, 0)

=if($(v_ShowHide)=1, 1, 0)

=v_ShowHide=1

=(v_ShowHide=1)

Here exactly the same as with the Ad Hoc  dimensions: working in dev and not working deployed on server.

Thanks in advance for any hint/clue you may have?

My QlikView desktop app is V11 and the server is V10, could that be the problem?

Cheers,

Lilian