Table Data Display Issue

[My_Rebecca]

The chart type is "Table",  column title "Storage Location", containing 0012_LCC DC NJ, 0016_LCC DC TJ, 0114_LCC DC NJ.

How to write expression to only display the data relevant to "0016_LCC DC TJ"?

I tried the expression {<[GR_Storage Location]={'0016_LCC DC TJ'}>}[GR_Storage Location], but now succeed.

[MartW]

you can use subfield, or maybe in this case use left.

the best thing to do this is in the load script. because if you use left I think this will become a calculated dimension. this will slow down Qlik sense a lot.

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc... 

[MayilVahanan · Accepted solution]

Hi

What is ur expression?

Try with set analysis for better performance, like

Sum({<[Storage Location] ={'0016_LCC DC TJ'}>}Sales)

Else, try with if condition in dimension, like

If([Storage Location] ='0016_LCC DC TJ', [Storage Location])
And suppress the null values in dimension

[Prem0212]

Here iam giving an example to you so that you can use this expression.

IF(right([Region],2)= 'st', Region)

Please like and accept the solution if u find an answer