Limit Dimensions for EXpressions

[#1]

Hi

In my example below:

Stage{Online,Telephonic),Month are my Dimensions.

Data and YTD are my Expressions.

Is there any possibility where in i can only apply Stage dimension on YTD and Stage + Month Dimension on Data

So that YTD will not have repeated Values .It will be added as a single column.

[tresB]

Though i am not very sure about your requirement, valueloop() or secondimensionality() function might help you. Can you please share a sample stating the requirement clearly?

[#3]

Hi Tresesco,

Straight Table Chart:

In simple terms: Say i have a single Dimension as Month.

And two Expressions : Sum(Sales) {which i have to calculate for each Month) and say another Expression "XYZ"

which doesnt need a dimension {its calculation is not based on  Month dimension}.

So i want to know is there any possibility in qlikview to restrict dimension on expressions

[tresB]

You can always bypass a dimension using TOTAL keyword. Like, if you use Sum( total Sales), will give you sales irrespective of dimension values in the chart.

[#5]

But the problem is i am getting it in this format. YTD is my another expression that is being shown with all the months.

I want that to be as single column as in fig 2.