topic Re: Select possible white feilds values basedon Groups in QlikView

Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 08:09:24 GMT

Team ,

I nned your help with one expression to filter KPIVALUES based on KPI group.

I have two fileds named

a:)KPIGROUP

B)KPINAME

Based on KPI group I nned to show only relevant (white values exclude greyed out one) KPI NAME.

I tried below expression and it do filters relevant WHITE KPINAME but when I select one KPI of the group , if I again filter to KPI name it does not show the entire POSSIBLE KPINAME again.

It just restrict me to the selected KPINAME only.

ONLY when I de-select the KPINAME filter ,it prrseesnt the full relevaht KPINAME agin.

=if(aggr(count(SectorUtilizationKPI),SectorUtilizationKPI),SectorUtilizationKPI).

Can you please suggest with modification expression that can help me to choose relevant KPINAME always.

Re: Select possible white feilds values basedon Groups

HirisH_V7 — Mon, 04 Jan 2016 08:44:16 GMT

Hi,

Can you post your sample app.

-Hirish

Re: Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 09:27:57 GMT

Hi,

PFA

Re: Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 09:31:05 GMT

Dear ,

PFA.

If you see when I select one KPI group K1 and if I filter to one of the relevant KPI and select one , if I AGAIN MOVE TO KPINAME filter ot does not shows me any other KPINAME.

Can you please help me with this.I nned to implement the logic in production env on urgent basisi.

Many thanks in advance.

Re: Select possible white feilds values basedon Groups

HirisH_V7 — Mon, 04 Jan 2016 09:42:41 GMT

Hi ,

why are you using expression like this,

=if(aggr(count(KPINAME),KPINAME),KPINAME)

Remove this and use ,KPINAME field only

Check this,

I did n't understood your requirement fully,

HTH,

Hirish

Re: Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 09:51:29 GMT

We need to show only white field value exclude the greyedout(not-asscoaited values).

This is th ereason we nned to use some expression to show only white filed values.

Can you please advise?

Re: Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 10:01:33 GMT

We need to show only white field value exclude the greyedout(not-asscoaited values).

This is th ereason we nned to use some expression to show only white filed values.

Can you please advise?

Re: Select possible white feilds values basedon Groups

settu_periasamy — Mon, 04 Jan 2016 10:30:09 GMT

Hi Avinash,

Your expression seems to be fine. =if(aggr(count(KPINAME),KPINAME),KPINAME)

And your MultiBox also working fine for Me.

And, I think, In the MultiBox, If you want to select other value, first you need clear the previous value, Then you need select the other Value.

For E.g KPI Group : K1

KPI Name : CALLCOUNT and DROPCOUNT (if you select CALL COUNT)

Suppose, if you want to select DROPCOUNT, you first need to clear the CALLCOUNT, Then select the DROPCOUNT.

But, May be Instead of the Expression, You can try the "Hide Excluded" in the Presentation Tab for KPINAME.

Check the Attachment May be helps..

Re: Select possible white feilds values basedon Groups

aj0031724 — Mon, 04 Jan 2016 10:40:38 GMT

Dear Settu,

This is what client is complaining about that they nned to clear the filter and then reselect again.

They want the relevant assocoiated filed values to show always based on group .They don't want to deselect and select again.

Any other approach or expression please suggest .....

Re: Select possible white feilds values basedon Groups

settu_periasamy — Mon, 04 Jan 2016 13:16:17 GMT

I just tried with ListBox Background in the MultiBox, Check if it suits for you...