Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone please help me solving below issue.
Load * inline [
Name, Center, Score
AAA, Berlin, 90
BBB, Berlin, 98
CCC, Mexico, 97
DDD, Mexico, 94
EEE, USA, 98
FFF, Argentina , 90 ];
I want to show in a table box with dimensions Name and Center and Expression as Score of individual Name and Total Score for their respective location/
like for example - when i select AAA, i need to show AAA score as 90 in one column and ONLY Berlin total Score as 188 (90+98) in another column a table box.
Can anyone please help me with this issue.
Thanks alot
maybe one solution could be:
Sum({$<Name=,Center=p(Center)>} TOTAL Score)
hope this helps
Marco
Hello, @Qlikuser225
To Ignore the section and continue bringing the total value, you can use the wildcard character * in your expression, for example:
Dimension={"*"}
maybe one solution could be:
Sum({$<Name=,Center=p(Center)>} TOTAL Score)
hope this helps
Marco