Enabling Expressions conditionally

[deepakqlikview_123]

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

[sunny_talwar]

Use SubStringCount() I think with or condition

[deepakqlikview_123]

Can u please share example

[Anonymous]

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.'

[sasikanth]

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

[deepakqlikview_123]

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

[sunny_talwar]

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

[Anonymous]

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.