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
sunny_talwar

The value of first row changed to 4100? or is that a typo?

priyarane
Specialist
Specialist
Author

values are changing irrespective of search

for ex if search <3000

and dimensions are picking and according to dimension availablity values are coming in expression

sunny_talwar

Would you be able to share a sample to show the problem

qlikview979
Specialist
Specialist

Can you please  share the sample app.

priyarane
Specialist
Specialist
Author

I don't have exact application and issue, but in my sample data it is showing kind of issues.

for ex I am searching <10 then I am expecting -1 value also.

This is the only one I have issue in sample data but with actual data values are also showing incorrect as said before

priyarane
Specialist
Specialist
Author

if you search like <20 then you are getting 3001, -1

qlikview979
Specialist
Specialist

Hi Priya,

Do like this

add recno()  as a dimension you will get correct result/

T1:

LOAD

recn0() as Rec,


Dim1,

    Dim2,

    Dim3,

    Sales

FROM

[data.xlsx]

(ooxml, embedded labels, table is Sheet1);

qlikview979
Specialist
Specialist

Here in your 3 dimension records  are same for some records ,that's why it taking sum of both records .

sunny_talwar

Seems like the issue is related to nulls in your dimension... try this

NULLASVALUE *;

Set NullValue = 'NULL';

LOAD Dim1,

    Dim2,

    Dim3,

    Sales

FROM

[data.xlsx]

(ooxml, embedded labels, table is Sheet1);

And then try the search