missing a syntax in my expression?

[dreweezy]

Hi QlikSense gurus,

I've got a dashboard that focuses on one state with 4 different cities. I have a pivot table with an expression - 

sum({<CITY_NAME={'LA', 'SAN JOSE', 'HOLLYWOOD', 'ABBOT'}, dept_code = {"542"}>} TOTAL_SALES)

When I cross check this amount in my sql database it is way overstated. I then tried taking out the 'dept_code = 542' syntax and put a filter pane with dept_code and looks to be changing the numbers to match what is in my sql. Any reason why this is behaving this way? Is my syntax incorrect? Thank you.

[RobertoObelar]

Tente o seguinte,

sum ({<dept_code =P ({1<CITY_NAME = { 'LA', 'SAN JOSE', 'Hollywood', 'ABADE' }>}dept_code )>} TOTAL_SALES)

Acredito que irá funcionar.

Abç.

[dreweezy]

Thank you - I have tried but no luck on this one.

[Channa]

sum({<CITY_NAME={'LA', 'SAN JOSE', 'HOLLYWOOD', 'ABBOT'}, dept_code = {'542'}>} TOTAL_SALES)

sum({<CITY_NAME={'LA', 'SAN JOSE', 'HOLLYWOOD', 'ABBOT'}, dept_code = {542}>} TOTAL_SALES)

this expression will bring cityname in (LA,SA Jose,hollywood,abbot ) and dept_code=542

chech if you looking for same

[dreweezy]

Channa, thanks for your reply. I actually already had the exact expression but for some reason it just does not read in the dept code. It is using all dept codes.. I find it very interesting on why it is behaving this way. The only thing I can think of why this is happening is maybe my load script. The only off putting thing in my load script is doing a left join on a spreadsheet with different column headers than my connected data source (sql db).