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: 
dickelsa
Creator
Creator

Inputsum

Hi all,

I have a problem with the inputsum() aggregation.

i cannot use it somehow.

this is the script:

INPUTFIELD FactTable.test;

FactTable:

LOAD Date,

     [Acc code],

     Value as test

FROM

[DC.xlsx]

(ooxml, embedded labels, table is Blad1);

Descr:

LOAD [Acc code],

     Descr

FROM

[DC.xlsx]

(ooxml, embedded labels, table is Blad2);

Calendar:

Load Date,

Year(Date)&'-'&Month(Date) as YM

RESIDENT FactTable;

when i change INPUTFIELD to just "test", it says it creates duplicate keys so it doesnt work.

Can anyone help me?

dashboard with source is attached.

Best regards,

Dick

1 Reply
dickelsa
Creator
Creator
Author

Update:

I found out that somehow, my field is not turned into an inputfield.

Can someone please help me?

Best regards,

Dick