Can anyone help me with expression as I have to show sum of rows data for below columns for each member
Contracts Hrs Holidays Taken casual gaining Meetings Other
Contracts Hrs = total of Contracts Hrs Holidays Taken = total of Holidays Taken casual = total of casual gaining= total of gaining Meetings = total of meetings other = total of other+audit+investigation+calls
do you want a running total basically in your chart? or opposite when your first row will sum all values below it, second row will sum all values below it etc.
I can able to see the total but I need the data to show as in attached . Is that possible? Please help.
for eg: if for one member the total sickness count hrs is 52.7 I don't want to make the 52.7 every time instead want to show based on day. is that possible?
calculation1,Heading1,if(calculation2,Heading2)) as new_Dimension,
If calculation field coming from different table.
Try to merge it in one table.
Regards
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
right, this is what I meant. Check "below" function in a help file and examples there - that function will work only in a chart (it is one of those inter chart functions) and will assume specific sorting order that user would not be able to change but I think it will work the way you want.
I would also spend some time and "unflat" your data file - right now you have your subtotals on one line per team/member and you would need to have them loaded horizontally like:
team, member, time_type, value
team 1, 137, contract Hrs, 3
team 1, 137, Holiday, 0
etc.
That way you can use new time_type attribute as one of your dimensions in a chart and sum up the time using the "below" function.
Remember about sorting - inter chart functions do not like sorting so you need to predefine sorting and disable interactive sorting for users.
