topic Re: Problem with the expression in QlikView

Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 06:34:07 GMT

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

Re: Problem with the expression

tresB — Mon, 13 Jul 2015 06:45:16 GMT

Two points:

SubStringCount(Concat(GetFieldSelections(WorkAreaName,';',9999)),'Mixed') - here concat() seems to be redundant, because the getfieldselections itself will generate a list/string of selected filed values
SubstringCount() would return TRUE/-1 if it finds a 'Mixed' anywhere in the resulttant string returned by inner function. That means, possibly there is 'Mixed' somewhere in your selection. Any doubt, request you to share a sample that demonstrates your issue.

Re: Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 07:05:25 GMT

I am not able to find the option to attach sample qvw

Re: Problem with the expression

tresB — Mon, 13 Jul 2015 07:07:46 GMT

Relpy->Use advanced editor(right top corner)->attach(right bottom corner)

Re: Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 07:10:14 GMT

In the sample if you see although W1 is not selected after selecting the date but still the text object is showing 1.

Re: Problem with the expression

jagan — Mon, 13 Jul 2015 07:20:08 GMT

Hi,

Try like this in text box if you find anything Mixed in the output then it will return -1,

=GetFieldSelections(WorkAreaName,';',9999)

Regards,

Jagan.

Re: Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 07:27:42 GMT

No , it is not working for all selections..

Re: Problem with the expression

tresB — Mon, 13 Jul 2015 07:30:53 GMT

Weird !

If you crear the selection from Work field and reselct it; issue goes. But somewhere, something is wrong; something is getting triggered. But no trigger is found nor a macro in your doc. I would contact support for their perusal - perhaps a bug.

Re: Problem with the expression

jagan — Mon, 13 Jul 2015 07:33:30 GMT

Hi,

Clear the selections and again do the selections in this order.

First select Date and then select Work.

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.

Re: Problem with the expression

settu_periasamy — Mon, 13 Jul 2015 07:34:22 GMT

Yes. There is one value selected. But in current selections show 3 values.

Re: Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 07:37:55 GMT

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

Re: Problem with the expression

settu_periasamy — Mon, 13 Jul 2015 07:45:38 GMT

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*')

Re: Problem with the expression

tresB — Mon, 13 Jul 2015 07:46:29 GMT

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.

Re: Problem with the expression

ferha_jafri — Mon, 13 Jul 2015 10:30:30 GMT

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

Re: Problem with the expression

tresB — Mon, 13 Jul 2015 10:42:28 GMT

Alternative way, like:

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

Re: Problem with the expression

sasiparupudi1 — Mon, 13 Jul 2015 11:01:07 GMT

Please try

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