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: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with Dual function

Hi all,

i have the attached qvw/excel sheet which load in report headings for a accounting GL dashboard.

the excel has 2 reports listed

     Balance Sheet

     Income Statement

with the headings for each report and the sequence

when loaded in the Income Statement is using the descriptions for the balance sheet and i am unsure why.

I know it is to do with the dual function but was wondering if anyone could get this working?

1 Reply
mjm
Employee
Employee

Hello hopkinsc,

I believe I understand what you are trying to achieve, but the dual function is basically used to assign a numeric value to a string, in order to sort it. This is often used for assigning a day number. From my understanding this is not what you want to achieve.

I would suggest using a simple concatenation like [Rpt Line Desc] & '-' & [Line Seq] as [Rpt Line Desc3]

I have attached an example qvw which may help.

If this helps, please mark this as answered and complete.