topic Re: Enabling Expressions conditionally in QlikView

Enabling Expressions conditionally

deepakqlikview_123 — Wed, 22 Feb 2017 09:39:27 GMT

Hi,

I have 8 expressions when I can click on All in radio button all expressions should be displayed when I can click on over 90 days in radio button only expressions over 90 days should be display.

Please suggest.

thanks

Re: Enabling Expressions conditionally

sunny_talwar — Wed, 22 Feb 2017 09:41:42 GMT

Use SubStringCount() I think with or condition

Re: Enabling Expressions conditionally

deepakqlikview_123 — Wed, 22 Feb 2017 10:46:48 GMT

Can u please share example

Re: Enabling Expressions conditionally

Anonymous — Wed, 22 Feb 2017 11:11:49 GMT

Use conditional Expressions.

For example if A,B,C,D,E,F,G,H are expressions, and EFGH are over 90 days then make 12 expressions ABCDEFGH with condition Getfieldselection(listbox) = 'All' and another EFGH Getfieldselection = 'over 90 days'.

Put a condition if there is a chance of selecting both 'all' and 'over 90 days.'

Re: Enabling Expressions conditionally

sasikanth — Wed, 22 Feb 2017 11:28:35 GMT

HI,

Need to know how did you calculate No. of Days, if it possible do it from script ,

*******************************************

LOAD

Start_date,

End_Date,

Interval(End_Date-Start_date,'DD') AS No.of Days,

FROM TABLE;

************************************

In chart Expression --> Conditional --> GetFieldselction(Radio_Field)='All' OR No. of Days>90

Re: Enabling Expressions conditionally

deepakqlikview_123 — Wed, 22 Feb 2017 11:43:28 GMT

Thanks Shiva,

It works fine can you please suggest how to show total of those column when >90 days selected and when All selected addition of All Columns should be displayed in Total column

Thanks

Re: Enabling Expressions conditionally

sunny_talwar — Wed, 22 Feb 2017 11:45:40 GMT

It would be easier if you can share a sample which is close to your actual scenario.

Re: Enabling Expressions conditionally

Anonymous — Wed, 22 Feb 2017 12:59:43 GMT

Try adding the column total with an expression as [Label of Expression1] +[Label of Expression2] + ......

Can you please share a sample .qvw depicting your scenario as stalwar1‌ asked.