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

[Anonymous]

invoice numbers are null actually they don't have invoice number

[Anonymous]

[sunny_talwar]

Is this Dual used as a dimension or measure? I want you to try using it as a dimension (if that's not what you are using it as)

[Anonymous]

I have added if then else to invoice number in load script saying that if invoice is null then ' '  else invoice number

then after the load is done......i have used the dual(invoice_number,rowkey)   ......its working for me now

combination of if then else in load script and using the dual function in report editor   ..it worked

Thank a lot.....let me check the data and get back to you to make sure its working