Help with Dual function

hopkinsc — Tue, 11 Nov 2014 10:52:18 GMT

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?

Re: Help with Dual function

mjm — Tue, 11 Nov 2014 12:40:06 GMT

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.

topic Re: Help with Dual function in QlikView

Help with Dual function

Re: Help with Dual function