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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-02 05:11 AM

Calculated Dimension and Expression

Hi Community,

this is an extension of my question posted in http://community.qlik.com/thread/89594.

Attached QV document shows top 2 metrics and their corresponding number of IDs.

Dim_01Dim_02Top 2CountSum
D_00<=C1_MAX_IND1??
D_00<=C2_MAX_IND1??
D_00>C1_MAX_IND1??
D_00>C4_MAX_IND4??

What I am trying to do is to calculate its sum as well.

My desire result is

Dim_01Dim_02Top 2CountSum
D_00<=C1_MAX_IND190
D_00<=C2_MAX_IND177
D_00>C1_MAX_IND166
D_00>C4_MAX_IND4141
Preview file
15 KB
DEV12 (3).qvw
462 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2013-09-02 08:17 PM
Author

Okay, I think I found an answer..

View solution in original post

Test.qvw
360 Views
0 Likes
1 Reply
Not applicable
‎2013-09-02 08:17 PM
Author

Okay, I think I found an answer..

Test.qvw
361 Views
0 Likes