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