Default value in Prompt - Qlik Community

livio218526 · ‎2017-12-05

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

OmarBenSalem · ‎2017-12-05

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:

livio218526 · ‎2017-12-05

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

I don't understand which Measure??

OmarBenSalem · ‎2017-12-05

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 · ‎2017-12-05

you can use the below extension:

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