topic Re: How to create dynamic If statement in QlikView

How to create dynamic If statement

Tue, 07 Jun 2016 07:42:34 GMT

Hi Friends,

I need your help to resolve my scenario . I need to change the logical operator in IF condition dynamically based on user selection, for Example please refer the below.

IF(Count(Distinct PARENT_REF_ID) $(testcheck) 1000 ,0,1)

The above Example the Testcheck variable has logical operator . This variable getting value from list box so here if the variable value is grater than symbol(>) then condition should be check the distinct value is greater than 1000 then return 0 or 1 .

Please help me to resolve this .

Thanks & regards

Antom

Re: How to create dynamic If statement

swuehl — Tue, 07 Jun 2016 08:47:31 GMT

And what is your exact issue?

Above should / could work, as far as I see.

If it's not, then please post a small sample QVW that demonstrates your issue.

Re: How to create dynamic If statement

Tue, 07 Jun 2016 10:35:36 GMT

Thanks Smuehi,

It's Working fine,

Re: How to create dynamic If statement

swuehl — Tue, 07 Jun 2016 11:56:31 GMT

Ok, then please close your thread as Assumed Answered.