Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

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

4 Replies
OmarBenSalem

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
Creator
Creator
Author

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

I don't understand which Measure??

OmarBenSalem

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
Partner - Champion
Partner - Champion

you can use the below extension:

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

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