topic Re: buttons in QlikView

buttons

Fri, 05 Jun 2015 14:28:23 GMT

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

Re: buttons

b_garside — Fri, 05 Jun 2015 14:33:08 GMT

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?

Re: buttons

Joaquin_Lazaro — Fri, 05 Jun 2015 14:44:54 GMT

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

Re: buttons

Fri, 05 Jun 2015 14:51:27 GMT

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

Re: buttons

Fri, 05 Jun 2015 14:57:04 GMT

thanks joa

Re: buttons

Joaquin_Lazaro — Fri, 05 Jun 2015 14:58:43 GMT

You're welcome

Re: buttons

Fri, 05 Jun 2015 16:27:43 GMT

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

Re: buttons

prabhas277 — Sat, 06 Jun 2015 03:39:19 GMT

HI, joaquinlr,

explain briefly i am not getting above post..

Re: buttons

Sat, 06 Jun 2015 08:54:48 GMT

thanks

Re: buttons

Sat, 06 Jun 2015 11:40:14 GMT

Try

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

Re: buttons

Joaquin_Lazaro — Mon, 08 Jun 2015 06:25:21 GMT

Hi PRRAJENDRAN:

I don't understand what you're trying to do with this expression.

But maybe you should use ;

vVAR = IF (Date(MonthStart(vMaxSalesDate)) >= Today() AND Date(MonthStart(vMaxSalesDate)) <= Today(), True(), False())

Hope this helps

Joaquín