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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight Table Set Analysis

Hello Community,

is it possible to get a value from a dimension within a straight table to be used in the set analysis of the measure that corresponds to it?

IE:

The Measure is  sum({<YEAR = {2017},BRAND1={'b1'}>}NUMBER_OF_REGISTRATIONS)

So the G/L measure would be for each line:

Line 1: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {260}>}NUMBER_OF_REGISTRATIONS)

Line 2: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {310}>}NUMBER_OF_REGISTRATIONS)

etc....

This is part of a larger calculation, though i need only this part to be filtered down by the specific Sales Area Code.

Thoughts?

1 Reply
sunny_talwar

If you have Sales Area Code as a dimension, doesn't it already showing the value associated with the Sales Area Code it belongs to... I wonder why would you need set analysis for something like this?