Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Fred12
Contributor III
Contributor III

How to display only 1 total on 2 different field

Hello, I have to compare value between 2 field like that : 

  FIELD 1 FIELD 2
TOTAL 100 000 100 000
A 50 000 100 000
B 20 000 100 000
C 10 000 100 000
D 5 000 100 000
E 15 000 100 000

 

Like you can see, for the field 1, I have categories A B C D E but for field 2, I have no categorie, so he display me 100 000 everywhere, but I would like to have 100 000 only for the total in field 2.  something like it :

  FIELD 1 FIELD 2
TOTAL 100 000 100 000
A 50 000 -
B 20 000 -
C 10 000 -
D 5 000 -
E 15 000 -

 

thanks in advance for reading me 

Labels (3)
1 Solution

Accepted Solutions
Fred12
Contributor III
Contributor III
Author

Hello, I come back to u to say u that I found solution. 

 

I needed to do :  

if dimensionality() <> 2, .....

View solution in original post

2 Replies
Andrea_Spinetti
Former Employee
Former Employee

Hello @Fred12, would you be able to share a dummy dataset like the one you are using for me and other members to test? I'm not sure I've fully understood your request. Thanks! 😊

If the issue is solved please mark the answer with Accept as Solution.
Fred12
Contributor III
Contributor III
Author

Hello, I come back to u to say u that I found solution. 

 

I needed to do :  

if dimensionality() <> 2, .....