Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

Default value in Prompt

Hi Everyone,

I want set a prompt in a default value of Field.

In particular I have a Field (Month) and I want set the prompt in a default value (Aug).

How I can do it??

Thanks,

Livio

Tags (2)
4 Replies
OmarBenSalem
Esteemed Contributor

Re: Default value in Prompt

Please use this extension since It's not possible directly with qlik sense (unless u use set expressions) and change all of ur expressions.

I mean sthing like,

If(GetSelectedCount(Month) = 0, Sum({<Month= {'Aug'}>}Measure), Sum(Measure)


here's a good extension:

GitHub - fadyheiba/DefaultSelections: Sets a default selection upon open a Qlik Sense sheet.

livio218526
Contributor

Re: Default value in Prompt

If(GetSelectedCount(Month) = 0, Sum({<Month= {'Aug'}>}Measure), Sum(Measure)

I don't understand which Measure??

OmarBenSalem
Esteemed Contributor

Re: Default value in Prompt

Each of the measures u have in ur sheet ! this is generic for the sake of the example..

It can be anything?

Sum(Sales)

Count(distinct ID)

Don't know..

agigliotti
Honored Contributor II

Re: Default value in Prompt

you can use the below extension:

http://branch.qlik.com/#!/project/58e20b0e86f54ab8e8f21512

it enable you to set a field value when opening a sheet.

Community Browser