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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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