Discussion board where members can get started with Qlik Sense.
I have a data like below
now I want to add one dummy value under and I need to sum up the specified records under SAL
In the above table GROUP 1 SUM is a dummy column which will sum SAL of ABC+DEF
I want to specify how many rows are need to be summed.
You can try below logic.
Load * inline [
Name, Group, SAL
Load Group as Name,Sum(SAL) as SAL Resident Data Group by Group;
Load Name, SAL resident Data;
Load 'Total' as Name,Sum(SAL) as SAL Resident Data;
Drop table Data;
I my table I don't have Group field. to group them.
That is something which you need to create to tell which values should be Grouped under what.
Thanks for the reply.
you are correct but, It is the sample data which I posted. but in real time in have very huge data. I cannot create GROUP manually.
forget about the SUM, can we add A dummy field atleast?
Like GROUP 1 SUM in the above table
You can use the Mapping function to map it from other source.
Hope you know how to use the apply map.