Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Greetings for the day!
I have 5 sheets in my QVW Main,Area1-U1,Area1-U2,Area2-U1,Area2-U2.
In Main sheet i have 2 list boxes Area, Unit. If user select Area1 as Area and U1 as Unit then 'Area1-U1' sheet should enable.
If user select multiple Areas like Area1,Area2 and Unit as U1 then 'Area1-U1' and 'Area2-U1' sheets should enable.
If user select multiple Areas like Area1,Area2 and Unit as U1 and U2 then 'Area1-U1' and 'Area1-U2' and 'Area2-U1' and 'Area2-U2' sheets should enable.
Please help me here i am attaching sample QVW also.
Thanks,
QV11 User
see the attachement, in tab general of each sheet properties
but i suggest to simplify the user interface, and use one sheet with one chart and the 2 listbox
use show hide objcts
Hi Suresh,
Thanks for reply.
Can you attach sample QVW?
Thanks,
QV11 User
see the attachement, in tab general of each sheet properties
but i suggest to simplify the user interface, and use one sheet with one chart and the 2 listbox
Hi,
Exactly same answer as Maxgro, but he was quicker than me.
I just use a different expression to show/hide sheet:
=GetFieldSelections(Area) like '*Area1*' and GetFieldSelections(Unit) like '*U1*'
But Idon't really understand why you want do that.
Hi ,
Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:
Hope this helps,
Hirish