Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selection Data

Hi Folks,

is it possible to get the 20 (out of 53) Weeks ready for a calculation?

selection.png

I only see, right now, with green weeks as follows:

selection2.png

that it is only possible to GetPossibleCount(Woche) = 16.

Whereas I would be very glad to have 20 for further calculations.

Any idea?

Thanks in advance,

Wolfgang

4 Replies
Digvijay_Singh

It appears to me as a impact of your selections in Herkunft and in the field below it as shown in your current selection box.

In your calculation if you disregard selections in those fields using Set analysis by using <Fieldname=; in the set expression, you should get 20 weeks for your calculations.

prieper
Master II
Master II

Woche 1-5 hat keine Daten hinterlegt, deshalb mit grauem Hintergrund.

Mit GETCURRENTSELECTIONS() und max-values auf 20 (oder 50), solltest Du die richtige Anzeige hinbekommen.

Peter

Anonymous
Not applicable
Author

Vielen Dank, Peter,

leider erschließt sich mir max.... Anfänger nicht wie das geht oder wie Du das gemeint hast mit
max-values auf 20

Wolfgang

prieper
Master II
Master II

getcurrentselections ([RecordSep [, TagSep [,ValueSep [, MaxValues

[, State]]]]])

Returns a string with the current selections in the document. It is possible to query an alternate state.

RecordSep is the separator to be put between field records. The default is <CR><LF>.

TagSep is the separator to be put between the field name tag and the field values. The default is ': '.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values

is selected the format 'x of y values' will be used instead. The default is 6.

Ähnlich mit

getfieldselections ( FieldName [, ValueSep [, MaxValues [,

State]]])

Returns a string with the current selections in a field. It is possible to query an alternate state.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values

is selected the format 'x of y values' will be used instead. The default is 6.

Die Rückgabe kannst du dann mit String-Funktionen weiter auswerten.

z.B.: SUBSTRINGCOUNT(GETFIELDSELECTIONS(Woche, '|', 100), '|') +1

Peter

edit: Stringfunction added