Hello All ,

I have the below expression to calculate the Total YTD Sales for top N Customers   but the expression is is returing 0 when the current month sales is Zero.

=Sum(Aggr(If(Rank($(eActualValueYTDRank)) <= $(vHospRank), $(eActualValueYTDRank)),ListHosp_Ranking))

Any insights on the issue is welecome.

Thanks

Kusha

hi , in my qv model i have classes , and for each there is a unique code .

by selection - its possible that the relevant code will be :

10,98,111,112,320 ..   or 10,11,34,320,441,501 ..    or 11,12,13,111,112,113,333,444 ..

the thing is that i need to set same colors for the same codes all over the model - at all tabs , all objects  ,

so the first code - no matter the value is - will be green, the socond will be red , the third blue ,  and so on ....

( according to the colors - Data Apearance palate  )

How can I do this in the simplest way?    THANS.

Table A:

ColumnName1,colmnName2

a                                   2

b                                  3

c                                  4

vVariable1=sum(columnName2) where columnName1=(a and b) i.e. vVariable1=5

i want sum (columnName2) with where condition(columnName2=a and b) and store into an variable vVariable1.

I would need to add one extra column to my table of X-rates, simply using one of the values in the table (EUR per USD xrate) and populate this value across all rows in my table. I thought it would be easy , but I can´t find the way to do it. 

Any help is appreciated. Here is the piece of code I am struggling with 

Directory;
LOAD
Country,
CURRENCY,
CODE,
USDperCURR,
CURRperUSD,
if(CODE='EUR',CURRperUSD) as EURperUSD
FROM 201906_MOR.xls (biff, embedded labels, table is Summary$, filters( .......));

I simply need the last calculated field to populate for all rows ...not only for the row where CODE=EUR ( like in attached printscreen ).

Thank you !!

Hi All,

I am unable to view/see my tables in table viewer. Please find attached screenshot

All the table are showing as white and if I export or copy then it is showing me table correct.

Kindly help.

Regards,

Mahamed