Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Have a straight table as below:
Month Name TM Limit Balance
Mar 2013 A Non Target 12 13
Mar 2013 B Select 24 6
Mar 2013 C Non Target 15 14
Mar 2013 D Target 8 13
Any guidance to show the records with Non Target only
rgrds
You could simply add a listbox for the TM field and select Non Target in it. But if you want that selection only for the straight table you can use a calculated dimension instead of TM, i.e. if(TM='Non Target',TM), and check the Suppress When Value is Null option for the calculated dimension. You can also put the filter in all the expressions: sum({<TM = {'Non Target'}>} Limit) and sum({<TM = {'Non Target'}>} Balance).
Another option in QV11 is to use an alternate state for both a listbox and the straight chart so selections in the lisbox only apply to the straight chart since it's in the same alternate state as the listbox.