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: 
Anonymous
Not applicable

Table measure not working line by line

Hi Guys,

I'm doing a table with two dimensions and around 11 or 12 measures, all the measures are displaying the correct data per dimension apart from one, can anyone see what i'm doing wrong and why this one isn't working.  I test the numbers in a KPI with the set analysis filtered to just one value from the dimension and it's right, but when i take the filter off and drop the whole expression in a table, i hope to see all the correct numbers per row for the values in the dimensions, 9 other measures are working as they should apart from this one.

The TEAM={"*"} filter in the set analysis is not working in this measure, where it is in others.

Sorry guys i've pasted the expression wrong, this is the correct expression

I want to divide each row of the dimesion by everything in that dimension

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},TEAM={"*"}>}Value)

/

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"}>}Value)

14 Replies
sunny_talwar

Are you looking to disregard any selection made in TEAM field? or are you trying to exclude rows where TEAM is Null?

For second option, what you have should work.

For first option, try this: TEAM = or just TEAM

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},STHA_DESC={"NHS Dorset CCG"}>}Value)

/

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},TEAM>}Value)

reddy-s
Master II
Master II

Hi Lak,

You do not have to specify TEAM={"*"} as your set modifier " 1 " it self refers to the entire data set i.e here TEAM={"*"} .

So try your expression removing it:

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},STHA_DESC={"NHS Dorset CCG"}>}Value)

/

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"}>}Value)

Anonymous
Not applicable
Author

Sorry guys i've pasted the expression wrong, this is the correct expression

I want to divide each row of the dimesion by everything in that dimension

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},STHA_DESC={"*"}>}Value)

/

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"}>}Value)

sunny_talwar

May be this (with TOTAL)

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},STHA_DESC={"*"}>}Value)

/

SUM(TOTAL {1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"},STHA_DESC={"*"}>}Value)

swuehl
MVP
MVP

Are you looking for the TOTAL qualifier? Do you want to ignore the dimension?

As always, context is important, so please tell us the dimensions used and some more details of your data model.

Also some sample lines of data and requested results always help to understand.

TOTAL qualifier (to ignore Dimension2, but consider Dimension1) may look like

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"}>} TOTAL<Dimension1> Value)

/

SUM({1<PRODUCT={"xxxx"}

,SID_MONTH={"201509"}>}Value)

Anonymous
Not applicable
Author

All i want to do is DIVIDE DIM 1 "A" SALES by total sales of A,B,C,D,E as a % as a measure

  

DIM 1 SALESMARGIN
A 3673836.37%
B 33833.35%
C 3023329.93%
D 1032210.22%
E 2033220.13%
sunny_talwar

For the sample above, this expression would work:

Sum(SALES) / Sum(TOTAL SALES)

you will need to adapt the above expression to your scenario.

Anonymous
Not applicable
Author

sales is a measure by the way not dimension.

I've tried your way, no figures are displayed

sunny_talwar

in your table have you tried DIM1 as dimension and Sum(SALES) / Sum(TOTAL SALES) as expression?