topic Re: Need help for - Conditional enabling of Expression and Dimension in QlikView

Need help for - Conditional enabling of Expression and Dimension

ananyaghosh — Thu, 23 Apr 2015 10:44:06 GMT

Hi,

I have created a Conditional enabling of Expression and Dimension in Qlikview and I made a condition like that user have to select at least one dimension and expression. But now I want to show dynamic error message in straight table as when user does not select any dimensions, he will get an error message and if user does not select any expression, he will get another error message.

So, I want to show error message based on the user selections. So how to do in straight table.

Thanks,

Sandip

Re: Need help for - Conditional enabling of Expression and Dimension

Thu, 23 Apr 2015 10:56:25 GMT

Hi Sandip,

you can set a calculation condition on the chart itself, which you set to ensure a dimension and expression has been selected. You can then adjust the message that is displayed by the failed condition.

Hope that helps

Joe

Re: Need help for - Conditional enabling of Expression and Dimension

ankitaag — Thu, 23 Apr 2015 10:56:39 GMT

Hi,

The condition should be

=if(GetFieldSelections(FieldName)>0,GetFieldSelections(FieldName),'Error- Dimension not selected')

same for the expression.

But to do it in a straight table, need a small sample data.

Do not attach the qvw as I have personal edition of qlikview..

Kindly attach a small excel or mention an inline.

Thanks and Regards,

Ankita

Re: Need help for - Conditional enabling of Expression and Dimension

jonathandienst — Thu, 23 Apr 2015 10:59:09 GMT

You can do a static error message by using conditional calculation with a custom error message. To do it dynamically, I would use conditional display of a text box and conditionally hide the text box and show the table when the user selects both a metric and a dimension.

So the conditional show of the table would be:

=GetSelectedCount(Dimension) > 0 And GetSelectedCount(Expresssion) > 0

And for the text box

=GetSelectedCount(Dimension) = 0 Or GetSelectedCount(Expresssion) = 0

And the could be dynamic like this:

=If(GetSelectedCount(Dimension) = 0. 'You need to select one or more dimensions. ', '') &

If(GetSelectedCount(Expression) = 0. 'You need to select one or more expressions.', '')

HTH

Jonathan