topic Re: Prob regarding Button in QlikView

Prob regarding Button

nikhilgarg — Mon, 23 Feb 2015 12:51:00 GMT

Hey,

I have a chart showing amount of commodities. Now i have created a button named YTD. I want that by clicking on YTD , my chart should show values of all commodities for whole current year. How can i change the values in chart by just clicking on YTD button??

tHanks

Re: Prob regarding Button

Anonymous — Mon, 23 Feb 2015 12:56:52 GMT

Put an action on the button of Type "Select in Field"

Re: Prob regarding Button

nikhilgarg — Mon, 23 Feb 2015 13:00:31 GMT

Ohk but does by inserting select in field option changes the values in

chart when i click the button? Do i need to set variable also?

Re: Prob regarding Button

yura_ratu — Mon, 23 Feb 2015 13:08:29 GMT

Hi Nikhil

Check this Dynamically Selecting Timeframes

Re: Prob regarding Button

Anonymous — Mon, 23 Feb 2015 14:50:15 GMT

Hi,

Create your button and add an action 'Select in the field'.

Select your date field

And add the action

= '>=' & YearStart(today())

Re: Prob regarding Button

Anonymous — Tue, 24 Feb 2015 04:25:11 GMT

Hi Nikhil,

You can create two different expression in your chart and enable/disable these expression based on the button value(0 or 1)

I have attached a sample application.

Hope this helps.

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 09:23:31 GMT

Hey Laxmi,

I am using personal edition so can you plz tell me the script you have written.

thanx

Re: Prob regarding Button

Anonymous — Tue, 24 Feb 2015 09:33:54 GMT

Hi Nikhil,

This is the sample table I have created in my application..

LOAD * INLINE [

COMMODITY, MTD, YTD

A ,100, 5

B, 200, 14

C, 160, 32

];

The chart is showing 2 different values, MTD and YTD. By default it will be MTS and when the user clicks on a button shown in the screenshot below 'YTD values' will be displayed. You can find the enable/disable conditions for both expressions in the screenshots. vYTDButton is the variable created to toggle between MTD and YTD values.

MTD Expression:

YTD Expression:

Button Action:

Regards,

Laxmi

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 11:28:42 GMT

Hey,

thanks but i didn't get it.

You ahve created only one button(Show MTD). On that button properties , you have set values:

if(vYTDButton = 0,1,0). : What does this 0,1,0 indicates??

In expression you have written 2 expressions :

For MTD , you have written ; if(vYTD = 1,0,1) , i didn't get this what does it means? and similarly for YTD expression.

Can you plz explain.

THnaks

Re: Prob regarding Button

Anonymous — Tue, 24 Feb 2015 12:13:02 GMT

Hi Nikhil,

There are 2 different expressions in this chart. One is to show the default values (i.e MTD in this example) and another on is for YTD. Whenever you click on the button vYTDButton=1 is set and whenever vYTDButton=1, the expression for YTD will be displayed and MTD expression will be hidden. When you click on that button again, vYTDButton will be 0 and MTD expression will be displayed.

The idea is to display/hide the expression in the chart based on the button clicked/not clicked.

Hope you understood. Let me know if you need more information.

Regards,

Laxmi

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 12:36:59 GMT

HEy,

Ohk i got your point.But there is something that i don't get.

In button properties: Value is 0,1,0 which means initially it is disabled(i.e 0) then after when it is clicked, it is enabled. Then again when we click it , it become again disabled(i.e 0)

Now how does expression in MTD and YTD affected ?? I don't understand the values given to their conditn ie:

MTD: if(vYTD = 1,0,1 ) ?

YTD: MTD: if(vYTD = 1,1,0 ) ?

Thanks

Re: Prob regarding Button

Tue, 24 Feb 2015 12:41:00 GMT

In Qlikview, if the fields are associated the data will get changed irrespective of where it is being used.

Can you please post the application with dummy data and requirement.

Thanks,

Singh

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 12:53:04 GMT

HEy angad,

Actually what i want to know is let say i ahve a chart showing amount of some commodities . I want the sum according to yearwise. So i created a button. Now by clicking on button how does chart changes. This is my concern.

If you see below laxmi has given a good example of that but i am confused between their values that is being assigned i.e 0 and 1. Can you help em in this ?

thanks

Re: Prob regarding Button

Tue, 24 Feb 2015 12:57:55 GMT

In that case, what you can do is, you can use conditional dimensions in your chart.

Suppose you have Month and Year as 2 dimensions. Now you can Enable or disable the dimensions based on the Button you click.

Is that whatver you are looking for?

Thanks,

Singh

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 13:04:22 GMT

Yeah but can you tell me how can i enable and disable dim on button click?

Re: Prob regarding Button

Tue, 24 Feb 2015 13:16:12 GMT

if you have created variables which populates with value = 1 when Button is clicked and 0 when clicked again.

Then just use,

varFlag = 1

in the Enable conditional for dimension.

Thanks,

Singh

Re: Prob regarding Button

nikhilgarg — Tue, 24 Feb 2015 13:23:30 GMT

HEy,

Ohk you mean create the button and under action tab, add SET variable variable with variable name varFlag and put value as 1. Now if i want that when i click on button it should show monthwise value then under dimension tab with Month as dim , i should put "var =1" in enable Conditional and for Year wise UNCHECK enable condition. Am i ryt ?

Re: Prob regarding Button

Anonymous — Wed, 25 Feb 2015 03:56:21 GMT

Hi Nikhil,

MTD: if(vYTD = 1,0,1 )

YTD: if(vYTD = 1,1,0 )

These are the enable condition for the MTD and YTD expressions. If the Button is clicked YTD expression is enabled otherwise MTD expression is enabled.

Laxmi

Re: Prob regarding Button

Wed, 25 Feb 2015 05:39:04 GMT

Exactly that is what I mean. Give it try and let us know about any issues you face.

Re: Prob regarding Button

nikhilgarg — Wed, 25 Feb 2015 12:48:05 GMT

Ohk so let say,

I clicked Button for very first time. Then value is '1'. Now, MTD expression will get disabled because if vYTD = 1 then 0 as per if(vYTD = 1,0,1 ) .

And YTD Expression will get enabled because if vYTD = 1 then 1 as per if(vYTD = 1,1,0 ) .

Am i ryt ??