Set analysis and Expression help

[Anonymous]

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

[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]

all my columns are dimesions except the transaction amount column

[sunny_talwar]

This?

[Anonymous]

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]

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

[Anonymous]

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?