topic Re: Data to Change on Selection......................!! in QlikView

Data to Change on Selection......................!!

aveeeeeee7en — Tue, 04 Nov 2014 06:26:44 GMT

Hi Community

Kindly, see the Attached Qvw to see my issue.

Regards

Av7eN

Re: Data to Change on Selection......................!!

tresB — Tue, 04 Nov 2014 06:36:16 GMT

Not sure if understood right, remove the latest status set part from the expression and try like:

=if(GetSelectedCount([Selection Filters])=0 OR GetFieldSelections([Selection Filters])='Current',Count({$<[Selection Filters]={'Current'}>}[Latest Status]),

count([Latest Status]))

in the sencond chart.

Re: Data to Change on Selection......................!!

Kushal_Chawda — Tue, 04 Nov 2014 06:48:09 GMT

Change the expression as

if(GetSelectedCount([Selection Filters])=0 OR GetFieldSelections([Selection Filters])='Current',Count({$<[Selection Filters]={'Current'},[Latest Status]-={'Offer Made','Recruiting','Vacant','Dropped','Shifted to Next Half'}>}[Latest Status]),

count([Latest Status]))

Re: Data to Change on Selection......................!!

aveeeeeee7en — Tue, 04 Nov 2014 07:49:45 GMT

Hi Tresesco & Kush

When I am writing this expression it is not working:

=if(GetSelectedCount([Selection Filters])=0 OR GetFieldSelections([Selection Filters])='Current',Count({$<[Selection Filters]={'Current'},[Latest Status]={"*"}-{'Offer Made','Recruiting','Vacant','Dropped','Shifted to Next Half'}>}[Latest Status]),

count([Latest Status]))

When I am writing this expression it is working:

=if(GetSelectedCount([Selection Filters])=0 OR GetFieldSelections([Selection Filters])='Current',Count({$<[Selection Filters]={'Current'},[Latest Status]-={'Offer Made','Recruiting','Vacant','Dropped','Shifted to Next Half'}>}[Latest Status]),

count([Latest Status]))

Why {"*"} is causing Problem........................???

Explain Me....................??

Regards

Av7eN

Re: Data to Change on Selection......................!!

tresB — Tue, 04 Nov 2014 08:03:37 GMT

[Latest Status]-={'Value1')} => Means, current selection in the field minus(exclusion) Value1. That is, it takes selection into consideration, whereas,

[Latest Status]={'*') -{'Value1'} => Means, irrespective of any selection in the field, all values (excluding null) minus(exclusion) Value1. That is it is fixed for the field.

Hope this helps.

Re: Data to Change on Selection......................!!

aveeeeeee7en — Tue, 04 Nov 2014 08:17:29 GMT

Sir

I have used the same concept in my many Applications.

But, My question is: " Why this Logic failing in my Scenario"????

This is something Serious or Misbehavior from Qlikview...............................???

When I am writing this expression it is not working:

count([Latest Status]))

When I am writing this expression it is working:

count([Latest Status]))

Regards

Av7eN

Re: Data to Change on Selection......................!!

tresB — Tue, 04 Nov 2014 08:28:23 GMT

This is NOT a misbehavior; it is working as expected. What I explained earlier is expected. Read 'Set Modifiers Using Assignments with Implicit Set Operators' from the help, that would possibly clear your doubt.