topic Re: Selection Data in QlikView

Selection Data

Anonymous — Tue, 16 May 2017 13:23:52 GMT

Hi Folks,

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

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

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

Re: Selection Data

Digvijay_Singh — Tue, 16 May 2017 13:32:36 GMT

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.

Re: Selection Data

prieper — Tue, 16 May 2017 13:32:48 GMT

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

Re: Selection Data

Anonymous — Tue, 16 May 2017 13:48:44 GMT

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

Re: Selection Data

prieper — Tue, 16 May 2017 13:55:50 GMT

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