Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use SubStringCount() I think with or condition
Can u please share example
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.'
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
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
It would be easier if you can share a sample which is close to your actual scenario.
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.