Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current selections versus total

I am currently trying to create a dimension on a cross tab which lets me easily compare the current selection to the total across all dimensions.

Basically I have two listboxes, A and B.  A user selects item 1 from A and item 2 from B.  I want a cross tab that shows sum of X and sum of Y along the rows, with the users current selections in column 1 and the sums for all selections in column 2.  Any ideas on how I might achieve this with a calculated dimension?

Thanks in advance!

11 Replies
Not applicable
Author

Hi mathew,

There is nothing cognos can do and qlikview can't do.

Try the attached document.

Suraj

Not applicable
Author

I am sure there is a more elegant way to do it (personally I would opt for the script change), but you can try a calculated dimension similar to the following:

=IF(MATCH(Group,GetFieldSelections(Group,','))=1,'Current','Others')

With an expressions of

=SUM({<Group=>}Value1)

=SUM({<Group=>}Value2)

I am pretty sure this won't perform well over large data sets.