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

[aveeeeeee7en]

Hi Community

Kindly, see the Attached Qvw to see my issue.

Regards

Av7eN

[tresesco]

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.

[Kushal_Chawda · Accepted solution]

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]))

[aveeeeeee7en]

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

[tresesco]

[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.

[aveeeeeee7en]

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:

=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]))

Regards

Av7eN

[tresesco]

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.