Prob regarding Button

[nikhilgarg]

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

[nikhilgarg]

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

[#3]

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

[nikhilgarg]

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

[#5]

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

[nikhilgarg]

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

[#7]

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

[nikhilgarg]

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 ?

[Anonymous]

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

[#10]

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

[nikhilgarg]

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