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: 
Anonymous
Not applicable

No values in chart at no selection in Listbox

Who can help me with the following issue?

If no selection is made in list boxes 'Season Actual' and\or 'Season previous (pp)' the values in the chart has to present 0.

The user immediately sees he has to make a selection in this boxes.

List box 'Season Actual' is based on field 'Year_Month' and alternate state 'SeasonActual'

List box 'Season Previous (PP)' is based on field 'Year_Month' and alternate state 'SeasonPrevious'

In chart 'Planning & Control in amounts' the field 'sBudget' has to show value 0 when there is no selection in list box 'Season Actual'.

The same applies to field 'sBudget (pp)' based on list box 'Season Previous (PP)'.


sBudget: Sum( {[SeasonActual] * $ } _Budget_amount)

SBudget(pp): sum( {[SeasonPrevious] * $ }  _Budget_amount)

No values at no selection list box.jpg

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe with an if based on getselectedcount function, State is the alternate state

getselectedcount (FieldName [, IncludeExcluded [, State]])

View solution in original post

1 Reply
maxgro
MVP
MVP

maybe with an if based on getselectedcount function, State is the alternate state

getselectedcount (FieldName [, IncludeExcluded [, State]])