topic Re: Expression in QlikView

Expression

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

HI,

In below image it can be seen that for contract no 1111111 and product 1 the value of 1st expression is 10 and for same contract no 2nd expression is 20 but both are showing in different row,What change i have to make in set analysis to bring both in one row??

Re: Expression

adamdavi3s — Tue, 27 Sep 2016 09:35:52 GMT

Can you share your existing formula please? (or even better an app)

Its hard to advise when we have no idea what is going on!

Re: Expression

avinashelite — Tue, 27 Sep 2016 09:36:10 GMT

I didn't get your question

" same contract no 2nd "expression is 20 but both are showing in different " I could see a different contract number .

Could you please explain more

Re: Expression

lionking15 — Tue, 27 Sep 2016 09:38:44 GMT

contract no 1111111 appearing twice in contract no column

Re: Expression

adamdavi3s — Tue, 27 Sep 2016 09:42:08 GMT

Because there is data not linked to aproduct?

I think we need to understand your data / formula / app as requested

Re: Expression

miguelbraga — Tue, 27 Sep 2016 09:43:00 GMT

Hey there,

We can't help you if you don't give information about the expression 1st and expression 2nd. Only then we can help you out

Best regards,

D.A. MB

Re: Expression

giakoum — Tue, 27 Sep 2016 09:44:55 GMT

{<Product_Code, Product_Name, .........>}

so that it is irrelevant of product. But I would suggest to fix it in data level not expression level

Re: Expression

avinashelite — Tue, 27 Sep 2016 09:54:30 GMT

We need to check both the expression then only we will be able to guide you ..please provide both the expression with sample data...

Re: Expression

lionking15 — Tue, 27 Sep 2016 10:03:29 GMT

Thanks Guys

I Done changes at back end and now i am getting correct data

Re: Expression

avinashelite — Tue, 27 Sep 2016 10:05:15 GMT

If you have got the answers , mark the helpful and correct answers