Problem with the expression

[ferha_jafri]

Hello Everyone,

I am facing problem with the expression

SubStringCount(Concat(GetFieldSelections(WorkAreaName,';',9999)),'Mixed')  in this expression if I select All in workareaname field and then select Name for which Workareaname is deselected (Greyed out) but still showing true not sure about the problem.

Regards

Ferha

[ferha_jafri]

Then what expression should I write for the above situation...

[settu_periasamy]

Actually, your expression is working. when i clear the work field and i re select the field.

Did you try the Jagan's Suggestion?

for testing purpose try this..

=wildmatch(Concat(Distinct Work,'|'),'*W1*')

[tresesco]

The issue is previously you selected all the Work values on top of that you selected Date, that is why you are getting one.

Regards,

Jagan.

In fact, that is how it is behaving. But the question is - 'Is it so by design ?'. If so, it would really create a lots of confusion.

[ferha_jafri]

Is it feasible to implement this condition in qlikview????

[tresesco]

Alternative way, like:

=If(GetSelectedCount(Work), SubStringCount(Concat(DISTINCT Work) ,'W1'))

[sasiparupudi1]

Please try

=if ((SubStringCount(GetFieldSelections(Work,';',9999),';')+1) <>GetSelectedCount(Work) ,'',SubStringCount(Concat(GetFieldSelections(Work,';',9999)),'W1'))