Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

When I display value in expression it doubled the value? Why?

Please look at the picture, the one in dimension displays correct value, while the one in expression, doubled the value, how to fix this?

why.png

Please help. Thanks in advance.

-Bill here

Tags (2)
3 Replies
Sokkorn
Honored Contributor

Why when I display value in expression it doubled?

Hi Bill,

Try expression : sum(DISTINCT sr.qty_returned)

Also check your data source for duplicate value.

Regards,

Sokkorn

Not applicable

When I display value in expression it doubled the value? Why?

In some parameters or query, it display correct data, so maybe it's in the datasource.

Not applicable

Re: When I display value in expression it doubled the value? Why?

Hi,

Yes most of the cases for occuring multiple values is having problem with when creating the datasource .

I too also faced such kind of problem after lots of test case i came to know that the data in the datasource itself having the mutliple values.

Regards
venkat

Community Browser