how to provide link for a button and chart in qliksense

[srujanaponnuru]

Hi All,

I have created a inline table as below:

Island:

Load * Inline [

_Metric

Revenue

Cost

ECL

FTE

RWA

];

In front end i have pulled as buttons using vizlib.

i have a bar chart where i am showing Actuals and Forecast as bar chart. 

Now i need to show if i click on Revenue button , in the bar chart i need to show the actauls bar. 

so i have written code as

if(Getfieldselections(_Metric) = 'Revenue', sum({<_Metric ={'Revenue'}>}[Actual Value]))

Now i have another buttons MTD YTD and QTD. 

How should i put in the above code if MTD is also selcted i need sum(actual value). can i put two parameters in getfieldselections.

Regards

srujana

[lironbaram]

hi
if you always have one value in the fields you can do 
if(_Metric= 'Revenue', sum({<_Metric ={'Revenue'}>}[Actual Value])),
so no problem to add other conditions 

[srujanaponnuru]

No, my requirement is

if i click on MTD button and Revenue button , i need to show the sum(actual value) in a bar chart. and in the same bar chart i also need to show other metrics as well. 

like:  

if(Getfieldselections(_Metric) = 'Revenue', or Getfieldselections(UnitofTime) = 'MTD' or Getfieldselections(_Metric) = 'ECL', or Getfieldselections(_Metric) = 'RWA', or Getfieldselections(_Metric) = 'FTE', sum({<Source = 'XYZ'>}[Actual Value]))

if i write the above code, if i click on Revenue button then i will the show actaul values of revenue, if i click on  RWA i will show RWA actual values in a single bar

and the revenue button should deselect.