Need help for Conditional enabling of Expression and Dimension in QlikView

qlikview

#1

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


#2

@ananyaghosh

You can create dynamic error message by writing expressions for “Error Message” under general tab of straight table.

Put expression as:

=if(GetSelectedCount(dimension_1) = 0 AND GetSelectedCount(Parameter_1)=0,'You have not selected any dimension or Expression',
if(GetSelectedCount(dimension_1) = 0 ,'You have not selected any dimension',
if(GetSelectedCount(Parameter_1) = 0 ,'You have not selected any expression'
)))

Hope this helps!

Regards,
Steve