Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a pivot table and i want to give conditional hidden.
I have a button.
Now, when i click on this button, then the chart has to get activated.
How can i do this without variables.
pls guide me...
Hi PRRAJENDRAN:
On object properties, 'Design' tab select conditional show and use a vVAR.
Set vVAR = TRUE() with a button or vVAR = FALSE() with a second button ... or toggle between both values with the same button
Hope this helkps you
Joaquín
Without a variable you can use an action Layout > Restore object which does not require a variable.
Is there a reason you don't or cant use a variable?
Hi PRRAJENDRAN:
On object properties, 'Design' tab select conditional show and use a vVAR.
Set vVAR = TRUE() with a button or vVAR = FALSE() with a second button ... or toggle between both values with the same button
Hope this helkps you
Joaquín
No.
I can use the variable.
if(VShowM =1,0,1) like this i used.
i have text boxes or buttons like MTD,YTD, WTD LastMTD, etc...
if i select the corresponding textbox or button, it should display the corresponding chart.
i have set variables for all these.
but the prob is, when i click on YTD, the chart got displayed, when i click on next MTD, the chart is not displayed.
again, i have to unselect YTD and then have to select MTD. i dont want this.
when i click MTD,it should get MTD chart, and if i select YTD, it should get YTD chart, etc...
i did the restore as u said, but again the same prob.
pls give suggestions............
thanks joa
You're welcome
Hi Joa,
I have to set variable for the following expression
'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'
when i give like
vCurrMnth='>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'
it is giving error.
Pls help me to solve this
HI, joaquinlr,
explain briefly i am not getting above post..
thanks
Try
vCurrMnth='>='&(Date(MonthStart(vMaxSalesDate))) &'<=' &(Date(vMaxSalesDate))