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: 
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
tresesco
MVP
MVP

It should not. Could you post a sample qvw that demonstrates the issue?

arulsettu
Master III
Master III

may be like this

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

Not applicable
Author

I tried even this:)

Anonymous
Not applicable
Author

Hi prudhvi,

Is this expression in a chart?

Could you share an screenshot please?

Regards!

Chanty4u
MVP
MVP

try this

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

ashwanin
Specialist
Specialist

Please try


=Count({1}{<[%rfflag],[Date]>}id)

Not applicable
Author

There are many field selections which have to affect this so, I cant use:

=Count({1}{<[%rfflag],[Date]>}id)

sasiparupudi1
Master III
Master III

Try

count({1<[%rfflag],[Date]>}id)

Not applicable
Author

no improvement