Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Issues due to nulls

Hi all,

PFA.

I have nulls in my  ActiveInactiveFlag.

for handling those I use pick match function.

But still value after'All' selection are not matching in active inactive flag.

My requirement is values after clear all and values after selecting All option for sum(CollectionAmount) should match.

Please suggest.

thanks

19 Replies
PrashantSangle

I am getting same value after clear all selection and by selecting ActiveInactiveFlag as 'All'

It is -950761.74431.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
kishorj1982
Creator II
Creator II
Author

I have uploaded the new file.

Thanks

PrashantSangle

add all values in pick(match()) against all search type

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
stabben23
Partner - Master
Partner - Master

If you look into ActiveInactiveFlagtemp Field, everything looks to work.

Maybe try to delete this part:

Flag:
Load ActiveInactiveFlagtemp,
ActiveInactiveFlagtemp as ActiveInactiveFlag
Resident  AddressBook;
Concatenate
Load ActiveInactiveFlagtemp,
'All'
as ActiveInactiveFlag
Resident
  AddressBook;

kishorj1982
Creator II
Creator II
Author

That part is required.

Because for All the values should be there after selection for All option in Active inactive flag.

Thanks,

kishorj1982
Creator II
Creator II
Author

RhanksWe need to show C , CP for Active selection.

Cx for inactive selection.

C,CP,CX and NULL in All selection.

In pick match function we are not able to repeat the values so I used

Flag:
Load ActiveInactiveFlagtemp,
ActiveInactiveFlagtemp as ActiveInactiveFlag
Resident  AddressBook;
Concatenate
Load ActiveInactiveFlagtemp,
'All'
as ActiveInactiveFlag
Resident
  AddressBook;

Thanks

sunny_talwar

What exactly are you trying to do here?

Pick(match(Search_Type,'C','CP','CX',''),'Active','Active','Inactive','All') as ActiveInactiveFlagtemp,

This is showing up as this...

Capture.PNG

Is this something you expected to see?

kishorj1982
Creator II
Creator II
Author

Whenever I am selecting All values for search type C,CP,CX ,'' also need to be displayed.

For Active-c,cp

Inactive-cx

all- C,CP,CX ,and blank

sunny_talwar

What about other Search_Type? J, U, E, B, EX, V? Those don't need to be selected?