Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik-Experts,
i already asked this question before in the community, but this time i prepare a really small app.
how is it possible to get the result of the yellow marked column without using the Total function (SUM), because I could use this value (98) for further calculations and in a pivot table this function does not exist anyway. I have already tried it with sum(aggr( but unfortunately I do not get the result I am hoping for.
Thank you for your support!
Best regards Son
May be other experts can help, but its a tricky situation, I have seen this odd behavior between pivot and straight table when the overall data model association creates null values. Some of the field values for Field_3 and Field_4 are not associated with any tester value and thats kind of making the difference here.
When I introduce testerA like this -
[Table-2]:
LOAD * INLINE
[
Field_2,Tester
B,TesterB
C,TesterC
A, TesterA
](delimiter is ',');
it makes proper associateion in the pivot -
Any issue with Sum(Field_2*Field_3)? Still trying to understand what do you mean by without using the SUM you are trying to get 60?
Thank you! This was a to simple test app.
The yellow marked column is exactly what i am looking for, without using the red marked function (Totals function (SUM)). Do you have any idea how to solve this?
I uploaded a new app now.
Where do you want Yellow highlighted column? In Pivot table? Sorry I am still not able to understand where do you want the final output?
This works in text box though in case you want to generate the same total as it shows in the table -
Sum(Aggr(Sum(Field_3)*Sum(Field_4),Tester))
Hi Digvijay
in a text box this is possible, but i am talking about the pivot table.
May be other experts can help, but its a tricky situation, I have seen this odd behavior between pivot and straight table when the overall data model association creates null values. Some of the field values for Field_3 and Field_4 are not associated with any tester value and thats kind of making the difference here.
When I introduce testerA like this -
[Table-2]:
LOAD * INLINE
[
Field_2,Tester
B,TesterB
C,TesterC
A, TesterA
](delimiter is ',');
it makes proper associateion in the pivot -