Expression Search

[priyarane]

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

[sunny_talwar]

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

[priyarane]

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]

Can you please  share the sample app.

[priyarane]

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]

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

[qlikview979]

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]

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