How to set the first value of a field as a filter?

[#1]

Hello everyone,

I am creating a chart where i need to apply the first value of the field "Process" as the default filter (view).

When the user open the dashboard, it is needed that the chart already display this first line of the dimension "Process".

The goal of this, is to not display too many information in the chart.

Thanks,

[sunny_talwar]

May be use OnOpen Trigger to select the Process value that you want to display?

[Chanty4u]

u can use bookmark....nd can u shre the screen shot?

[Mark_Little]

Hi,

Sunny's advise would achieve what you want?

Have you considered just applying a calculation condition to the chart in question?

Mark

[miguelbraga]

Hey there Rodrigo,

You can use the combination of both solution provided by Sunny and Sureshqv. You can do a trigger action on the sheet where your chart is and apply a preset bookmark that you've previously chose as the default. If you need further explanation on how to do it, please be my guest and ask for it

Thanks,

MB

[#6]

Hi guys,

Thanks for your answers.

I guess Sunny´s advise would not achieve want i want, because i have other charts in my sheet that cannot have the trigger action, only one chart should consider this action. I am not sure how to do that.

Please MB, could you provide me further explanation on how to do it?

Thanks a lot

[miguelbraga]

Check out this sample:

[sunny_talwar]

You can use an alternate state which has that selection locked down. There are might be few options available but not sure how to tell which would be the best for you.

[miguelbraga]

My explanation is bellow, you can also set a variable like this:

vView = (your default value)

And on the triggers in sheet properties set the field as the variable, don't forget to put the variable like this:

$(vView)

Check it out how it's done in the qvw sample I provided.

MB

[#10]

One important thing i forgot to mention, the first value of the field can be changed sometimes, so i can´t set the the same default value. It should get the last value of the field. Is there a function on QV to get the last value where i can set in the variable as you suggested MB?

Thanks