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: 
priyarane
Specialist
Specialist

Expression Search

Hi Community,

I am including search option on expression in straight table but values are showing wrong in the table like below

for ex:

Straight table data

Dim1|Dim2|Dim3|Expression-Sum(Sales)

A|B|C|100

A|D|X|3000

G|B|D|40

Z|ZX|C|4000

so here I am searching <3000

Then I am expecting results like

A|B|C|100

A|D|X|3000

G|B|D|40

But I am getting results like below

A|B|C|4100

A|D|X|3000

G|B|D|40

Can some one pls suggest.

-Priya

11 Replies
priyarane
Specialist
Specialist
Author

it is not working

priyarane
Specialist
Specialist
Author

It is not working, i tried with <3000 still I am getting 3001