topic Limit Dimensions for EXpressions in QlikView

Limit Dimensions for EXpressions

Thu, 05 Sep 2013 05:43:15 GMT

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.

Re: Limit Dimensions for EXpressions

tresB — Thu, 05 Sep 2013 06:12:57 GMT

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?

Re: Limit Dimensions for EXpressions

Thu, 05 Sep 2013 06:24:16 GMT

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

Re: Limit Dimensions for EXpressions

tresB — Thu, 05 Sep 2013 06:32:57 GMT

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.

Re: Limit Dimensions for EXpressions

Thu, 05 Sep 2013 07:10:53 GMT

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.