topic Re: Expression Search in QlikView

Expression Search

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Expression Search

sunny_talwar — Wed, 24 May 2017 11:08:56 GMT

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

Re: Expression Search

priyarane — Wed, 24 May 2017 11:17:53 GMT

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

Re: Expression Search

sunny_talwar — Wed, 24 May 2017 11:20:49 GMT

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

Re: Expression Search

qlikview979 — Wed, 24 May 2017 11:22:50 GMT

Can you please share the sample app.

Re: Expression Search

priyarane — Wed, 24 May 2017 11:54:58 GMT

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

Re: Expression Search

priyarane — Wed, 24 May 2017 11:58:42 GMT

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

Re: Expression Search

qlikview979 — Wed, 24 May 2017 12:06:39 GMT

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

Re: Expression Search

qlikview979 — Wed, 24 May 2017 12:10:07 GMT

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

Re: Expression Search

sunny_talwar — Wed, 24 May 2017 12:14:16 GMT

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

Re: Expression Search

priyarane — Wed, 24 May 2017 13:19:54 GMT

it is not working

Re: Expression Search

priyarane — Wed, 24 May 2017 13:20:20 GMT

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