Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

neelima_alapati
New Contributor II

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
MVP
MVP

Re: Set analysis and Expression help

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

MVP
MVP

Re: Set analysis and Expression help

May be this

Dimension

Dual([Invoice Number], rowkey)

neelima_alapati
New Contributor II

Re: Set analysis and Expression help

all my columns are dimesions except the transaction amount column

MVP
MVP

Re: Set analysis and Expression help

This?

Capture.PNG

neelima_alapati
New Contributor II

Re: Set analysis and Expression help

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

MVP
MVP

Re: Set analysis and Expression help

‌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?

neelima_alapati
New Contributor II

Re: Set analysis and Expression help

Capture.PNG

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

Capture2.PNG

neelima_alapati
New Contributor II

Re: Set analysis and Expression help

sent now

MVP
MVP

Re: Set analysis and Expression help

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