Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
lionking15
Creator
Creator

Expression

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??doubt.png

9 Replies
adamdavi3s
Master
Master

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!

avinashelite

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

lionking15
Creator
Creator
Author

contract no 1111111 appearing twice in contract no column

adamdavi3s
Master
Master

Because there is data not linked to aproduct?

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

giakoum
Partner - Master II
Partner - Master II

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

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

avinashelite

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

lionking15
Creator
Creator
Author

Thanks Guys

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

avinashelite

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