buttons

[#1]

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...

[b_garside]

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?

[Joaquin_Lazaro · Accepted solution]

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

[#4]

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............

[#5]

thanks joa

[Joaquin_Lazaro]

You're welcome

[#7]

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

[prabhas277]

HI, joaquinlr,

explain briefly i am not getting above post..

[#9]

thanks

[#10]

Try

vCurrMnth='>='&(Date(MonthStart(vMaxSalesDate))) &'<=' &(Date(vMaxSalesDate))