Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
TBQlikNewbi
Contributor II
Contributor II

Calculated Dimension (?)

Currently, I have  =RegionCode as a 2nd dimension in a bar chart, where RegionCode is a table field.  The request is to put a sales variance count after the RegionCode.  So I'm trying to concatenate RegionCode with a set expression as follows, and keep getting "Invalid Dimension".  

 

RegionCode & ' - ' &

(

count({< StatusCurr={'Actual'}, SourceCurr={'JDE'}, ActivityTypeCurr={'Agreement TBI'} , LotStatusCodeCurr={$(vLotStatusCode)}, ActivityDateCurr={">=$(=Timestamp(YearStart(left((vCurrentDate),10), 0,11)))<=$(=Timestamp(left((vCurrentDate),10)))"}>} ActivityTypeCurr)
-
count({< StatusCurr={'Actual'}, SourceCurr={'JDE'}, ActivityTypeCurr={'Agreement Lost'} , LotStatusCodeCurr={$(vLotStatusCode)}, ActivityDateCurr={">=$(=Timestamp(YearStart(left((vCurrentDate),10), 0,11)))<=$(=Timestamp(left((vCurrentDate),10)))"}>} ActivityTypeCurr)

)

0 Replies