Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys!
I am new to QlikView. I've noticed that using Pivot Table, data with null/zero values are not displayed. If I checked the Suppress Zero Values in the presentation tab, it appears that it ignores the filter in the set analysis just to display the record with null values.
Example
Id | Name | Month | Year | Amount |
X | John Doe | 5 | 2020 | 10000 |
Y | John Doe Jr. | 5 | 2020 | Null |
Z | John Doe III | 5 | 2020 | 20000 |
XX | Joana Doe | 5 | 2020 | 30000 |
YY | Justin Doe | 5 | 2020 | 40000 |
Using Pivot Table sheet object, John Doe Jr. is excluded in the display.
What Am I missing guys?
BR, jess
Hi Guys,
If you encounter issue of this kind, here is what I did to resolve it.
1. Make sure that the SalesAmount in expression is not null in the dataset.
2. In the set analysis express add [SalesAmount] = {"<>0"} as an added filter.
3. Uncheck the Suppress zero-value in the presentation tab.
4. If you don't do no. 2, doing no. 3 will blow your presentation as it ignores other filters.
I don't know if this behavior is by design or a bug but I am expecting that qlik should display all data for as long as within the scope of the filter without the workaround. I consider the steps as a workaround.
BR, jess
For me this is Straight table not pivot? What column you are transposing to Row?
Hi, The info I gave is just a simple table but the context of the problem is the same. We are using Pivot Table because that's the right sheet object we should be using. The amount is the fact expression, the rest are dimensions.
Hi Guys,
If you encounter issue of this kind, here is what I did to resolve it.
1. Make sure that the SalesAmount in expression is not null in the dataset.
2. In the set analysis express add [SalesAmount] = {"<>0"} as an added filter.
3. Uncheck the Suppress zero-value in the presentation tab.
4. If you don't do no. 2, doing no. 3 will blow your presentation as it ignores other filters.
I don't know if this behavior is by design or a bug but I am expecting that qlik should display all data for as long as within the scope of the filter without the workaround. I consider the steps as a workaround.
BR, jess