topic Re: Exclude text from GetFieldSelections to use in a label in QlikView

Exclude text from GetFieldSelections to use in a label

tinkerz1 — Mon, 22 Jun 2015 14:12:35 GMT

I am trying to figure out how to use an expession for a label, I know if I exclude *threshold* I will return one value, but hbow do I get to it?

={<'*Threshold*'<>{$(=GetFieldSelections([ABC],',',3)}>}

Re: Exclude text from GetFieldSelections to use in a label

sunny_talwar — Mon, 22 Jun 2015 14:42:31 GMT

So you want to see your field selection in the label, but want to exclude anything which has *Threshold* in it? Is that what you question is? If yes, then try this:

=Concat(DISTINCT {<ABC = e({<ABC = {'*Threshold*''}>})>}ABC, ',')

Re: Exclude text from GetFieldSelections to use in a label

tinkerz1 — Mon, 22 Jun 2015 14:57:35 GMT

Ih Sorry, there is error in set modifier expression, I am still learning so cant figure it out

Re: Exclude text from GetFieldSelections to use in a label

sunny_talwar — Mon, 22 Jun 2015 15:00:12 GMT

Sorry, I placed two single qoutes at the end, try this:

=Concat(DISTINCT {<ABC = e({<ABC = {'*Threshold*'}>})>}ABC, ',')

Re: Exclude text from GetFieldSelections to use in a label

tinkerz1 — Mon, 22 Jun 2015 15:10:59 GMT

Thank you so much I would never have found it.

Re: Exclude text from GetFieldSelections to use in a label

sunny_talwar — Mon, 22 Jun 2015 15:12:37 GMT

Is it giving you the output you are looking for?

Re: Exclude text from GetFieldSelections to use in a label

tinkerz1 — Mon, 10 Aug 2015 15:58:10 GMT

Ok getting there thanks for this,

=if(GetFieldSelections([Issue],';',1)='temp',count(DISTINCT[ID]))

Why do I get a bad field name on Distinct.

This is also an alternate state so I assume I dont need to label this in the formula.

Thanks.