TOTAL in calculated dimensions

Mon, 23 May 2011 09:30:08 GMT

Hi,

I'm trying to use this expression:

count(total<TIMESTAMP,COUNTRY> distinct ID)

The problem is that I want to use it in a dashboard whose dimesions are TIMESTAMP and a calculated dimension COUNTRY-CITY

Do you know how can I get the result of that expression using calculated dimensions?,

maybe calculating the dimension in the script? (I don't know how to do it)

Thanks,

David

prieper — Mon, 23 May 2011 09:35:38 GMT

Would always recommend to create a dimension in the script, like

LOAD

COUNTRY & '-' & CITY AS CITY_id

FROM ....;

HTH
Peter

topic TOTAL in calculated dimensions in QlikView