Discussion Board for collaboration on QlikView Scripting.
I have an Excel list:
but I would have an Excel list or anything that I can load up to my application
I Need a new calculated row with sum.
Do you know, how can manipulate the list with a formula inside.
You can load the first excel file and create a chart with qlik that computes total
Let me know
I Need besides the sum formula nor a Division function.
Maybe can I load the Excel in a QVD File and after that I can manipulate the sum in the file.
kannst Du Deine Anforderungen bitte etwas präzisieren?
Wenn es nur um die Darstellung einer Summe geht, so ist der Vorschlag von Alessandro Saccone der Richtige.
Ok, i will try my requirements more exactly.
I have table with illnes days and Holiday days as Excel List (see above, first table).
I want to have a list, which the list will include a calculated sum Formular of the two items Illness days and Holiday days and a calculated Division field of the two items. (see above, second table).
How I get the two forumula in the Excel List or maybe in qvw file, that i can upload one list with the calculated items.
Can anybody help me.
lOAD * INLINE [
Header 1, Header 2
Illnes day, 2
Holiday day, 3
sum(if([Header 1]='Illnes day',[Header 2]))+sum(if([Header 1]='Holiday day',[Header 2])) as [Absence days]
resident tab1 ;
drop table tab1;
How I get a table with the following Format, that i can get a diagramm table in the app view:
Can you help me!
see the attched file
hope this helps
Is there any possibility for this Format:
presence in % 1-((sum([Absence days]))/ (sum([working days])))*100