Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a report with one chart, one straight table and four filters as list boxes.
I would like to make the straight table to be filtered from only 3 list boxes and to not depend from the 4-th listbox.
The values from the 4-th listbox are used in the straight table dimensions like column1 =IF([Idfrom 4-th listbox] = 3, value1, 0 ), column2 =IF([Idfrom 4-th listbox] = 4, value1,0) column3 =IF([Idfrom 4-th listbox] = 5, value1, 0) and a summary column like an expression which sums all mentioned values. So all these values should be visible at any time , no matter what is selected within the 4-th lisbox contaning Id`s.
How to do this?
Best Regards,
D. Petrov
Hi,
How are you obtaining the values for fourth list box. If you want 4 list box data to be independent then create it as Data Island (not to associate with any table). Then any selections on that will not have impact.
If possible, please share the sample qvw.
--Priya
What is your expression in the table?
Hello Priya,
Sadly, but the data is confidential and cannot post the report.
Best regards,
Dragomir
The expression is:
NUM((IF(ID = 7, HC_WP,0) + IF(ID = 6, HC_WP,0) + IF(ID = 2, HC_WP,0) + IF(ID = 3, HC_WP,0) + IF(D = 4, HC_WP,0)),'##.00')
While dimensions are:
=IF(ID = 7, NUM(HC_WP,'##.00'), 0)
=IF(ID = 6, NUM(HC_WP,'##.00'), 0)
etc...
This ID is in filter 4, which I would like not to affect the table.
Best Regards,
Dragomir