Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis and Expression help

Hi ,

I have Data present at Invoice number and Row key level. And in the chart i want to see the data by row key level itself even though it is not part of the chart. This is in Qlik sense not qlikview. Please see attached Sample data and let me know if that can be done.

Yaar Sunny this is Vinay .. need your help  stalwar1

13 Replies
sunny_talwar

May be using Dual function? What is the dimension that you use?

sunny_talwar

May be this

Dimension

Dual([Invoice Number], rowkey)

Anonymous
Not applicable
Author

all my columns are dimesions except the transaction amount column

sunny_talwar

This?

Capture.PNG

Anonymous
Not applicable
Author

yes...i did added dual(invoice no,rowkey)...i notice nothing changed

sunny_talwar

‌what are you hoping would change? is the screenshot not what you are looking to get? I see all rows without adding rowkey as a dimension? Is that not what you want?

Anonymous
Not applicable
Author

Capture.PNG

THis is the output needed but with the dual function i am getting below output

Capture2.PNG

Anonymous
Not applicable
Author

sent now

sunny_talwar

I don't see the use of dual function? Where did you use it? and why are all  Invoice number all blank?