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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.

Labels (1)
12 Replies
sasiparupudi1
Master III
Master III

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

tresB
Champion III
Champion III

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)