Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

%fields and its effect

Hi,

I have a field say [%rfflag]. it got values 'Y','N' and have a expression say count({<[%rfflag],[Date]>}id).

I don't want [%rfflag],[Date] fields affect the count of id's . So , ihave coded this way but when I make selections for the [%rfflag]; it is actually affecting the count of id's.

Can anyone tell me wats going wrong.

12 Replies
sasiparupudi1
Master III
Master III

count({<[%rfflag]={*},[Date]={*}>}id).

tresesco
MVP
MVP

No improvement in your response as well. You have to help us here to be helped. Please share a sample  and check the link to know how . Preparing examples for Upload - Reduction and Data Scrambling

sasiparupudi1
Master III
Master III

Hi

try with only %rfflag and see if it the selections still affecting the count? 

count({<[%rfflag]=>}id)