topic Re: how to set default field value in QlikView

how to set default field value

Wed, 25 Nov 2020 16:16:04 GMT

Hi there

How can i set the 3 charts default to "BT" without need to click on the button "BT"

where the field is "ct" and value is "b"

i tried use the expression =ct='b' in the dimension but doesnt work.

Thanks

jagan — Mon, 31 Oct 2016 09:18:16 GMT

Hi,

Try like this in dimension

If(ct='b', ct)

Hope this helps you.

Regards,

Jagan.

jagan — Mon, 31 Oct 2016 09:19:17 GMT

or you can handle in your expression like below

Sum({<ct={''b}>} MeasureName)

The above expression is a sample you can change it accordingly.

Regards,

Jagan.

Mon, 31 Oct 2016 09:34:33 GMT

Hi,

To set a default field value, we can actually use a trigger in sheet properties as shown below.

So whenever you are navigating to that sheet, by default the field 'ct' will be set to 'B'.

Regards,

Vivek