How to handle - in Qlik

[Vinod]

Hi All,

How to handle - in Straight table without using Suppress null values and without using excluding condition in set analysis.

Thanks,
Vinod

[marcus_malinow]

What are you trying to achieve?

What does your data look like?

What does the result you are aiming for look like?

[Vinod]

Below field is having some hypon(-), i want to remove that without using Suppress null value option and without using excluding condition in set analysis.

Periodic Maintain Pitch
5K
10k
40k
-
5K
10k
40k
-
5K
10k
40k
5K
10k
40k
-
5K
10K
40K

[marcus_malinow]

Ok, I'm assuming that these are null values in your dimension, and that you have expression data related to these.

You could suppress the data during the reload.