Suppress null values in dimension

[Anonymous]

Hi All,

I have created pivot table for rolling seven days. Here am facing one issue in suppress null values.

Requirement:

I have to show the number of unapproved deviations count in last seven days by Company wise.

In my data source i don't have data for all days, for example if any deviation got closed on that day data will be entered into source. So business expecting 7 days data if  data is not available include master calendar and add those days also so i have created like this by using master calendar.

Here i need to exclude the highlighted '- ' Company values.

why the '-' has appeared in source itself I don't have data so the remaining days (0726,07/27,07/28,07/29,07/30) has not mapped in source.

FYI

In straight table it's not mapped

I have tried in dimension & presentation tab to exclude the null values and also i tried to exclude the '-' values by using calculated dimension (not equal to and length) but it's not working as we expected.

Finally am expecting output like second screenshot to exclude the suppress null value(highlighted area only).

Regards,

Yuvaraj G

[qlikviewwizard]

Hi,

can you share the sample application?

[Anonymous]

Am not able to attach the qvw file.

[qlikviewwizard]

Try like this.

[Anonymous]

Hi Arjun,

Please find the attachment.

[jyothish8807]

Hi Yuvaraj,

You can suppress the value by simply checking the "Suppress Null Value" option.

[Anonymous]

I need in between days from 07/17 to 07/23 date also, please refer second screenshot highlighted in red color

[jyothish8807]

Hi Yuvaraj,

As per your data model the other dates are mapped to a blank field, so it wont be possible to suppress this part unless you fix your mapping.

[balabhaskarqlik]

Chain	Category
Chain 1	19.8%

Chain 1.1   10.3%

Chain 1.2   11.0%

Chain 2	0.4%
Chain 3	14.6%
Chain 4	3.3%
Chain 5	2.8%
Chain 6	0.4%
-	100.0%

Your data might be, same like above, then try your expression like this:

sum(Spend)/sum({<Chain=>} total <Category> Spend)

OR

Try like this:

If(Sum({$<CTI_DESC1={"OPEN DISC (100%)"}>}QTY) = 0, Null(), Sum({$<CTI_DESC1={"OPEN DISC (100%)"}>}QTY))

[Anonymous]

is that possible to hide that particular column like below screenshot