Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser225
Contributor III
Contributor III

Qlik Sense - Igonore selective dimensions

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

Labels (6)
1 Solution

Accepted Solutions
MarcoWedel

maybe one solution could be:

 

Sum({$<Name=,Center=p(Center)>} TOTAL Score)

 

MarcoWedel_0-1664914307534.png

hope this helps
Marco

View solution in original post

2 Replies
MatheusC
Specialist
Specialist

Hello,  @Qlikuser225 

To Ignore the section and continue bringing the total value, you can use the wildcard character * in your expression, for example:

Dimension={"*"}

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
MarcoWedel

maybe one solution could be:

 

Sum({$<Name=,Center=p(Center)>} TOTAL Score)

 

MarcoWedel_0-1664914307534.png

hope this helps
Marco