Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
i am having some issue with default filters
in my QVW dashboard i have 2 sheet.and 2 sheet have default filters ...for default filters i created using sheet properties-->trigger tab-->on activate sheet
now i want to disable the default filters when i navigate to one sheet to another sheet
like
sheet1 : (we have some other filters like office id,office name)
default filters:
name :a,b
id: 1,2
sheet2 (we have some other filters like group id,main groupname)
default filters:
group 1: kar,char
group2:max,min
for example in sheet 1 if i clear all default filters and i selected only one filter like:office name : deb
after that when i navigate sheet 2 ...again i was navigating from sheet2 to sheet1 ...i was able to seeing default filter with my eariler seletion
like:
name :a,b
id: 1,2
office name : deb
here how can show only office name filter
please help me
Regards,
Bob
I think you will need to implement a condition within your actions, something like:
if(getactivesheetid() = 'SHxx', ....
- Marcus
Thanks
i hope now there is one approach to fix my requirement
Can you give a small example or more explanation
then i will do further process accordingly
Note:
this process will work for newly introduce column like in feature if i add new columns in QVW dashboard
Regards,
Bob
I have no example for this. You need to play a bit with these approach ... If I think about it I would write the sheetname from the leaving sheet into a variable per DeActivate trigger and evaluate this value within the arriving sheet, like:
if('$(vLastActiveSheet)' = 'SH01', '(value1|value2)', '(value3|value4)')
or maybe Null() or ImAnError() within the then/else part to clear selections or create an error which meant that this action will ignored and the existing selections remain.
- Marcus