Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rfreire06
Contributor III
Contributor III

Dimensions with "null" values go hidden when filter is applied

Hello everyone.

I have a pivot table which shows the amount of products (letters in the pivot table) sold to each client (represented by numbers). As you can see, not every client buys every single product, and my main goal is to show which products they buy and which they do not. However, when I set a filter to show only one client, I miss the information of which products they do not buy, as the dimensions that are "null" go hidden.

At first, I thought these dashes represented null values, but when I tried to test it through the IsNull function, they did not show as -1 and remain as dashes.

This is the expression for the values shown in the pivot table:

sum({<[MovNF Código MovCtb] = {100,109,110,112,123,131,132,133,134,140,142,143,149,152,156,162,168,169,181,186,139,145,197,199},

[NF Flag Status] = {'N'}>}

[MovNF INDICE QUANTIDADE]*[Produto Valor Quantidade Embalabem])

pivot table.PNG

1 Reply
agigliotti
Partner
Partner

it depends how the data model is.

I think when you select a client, you'll se only the products sold to him.

If you need to show also the products he did not buy you could use a data island table.

---

Data islands can be created from any data source and are often created as an inline table. Data islands can be used to refer dates, table headers, or what ever you need to disconnect from most of the existing data in the data model.

---

take a look here https://www.linkedin.com/pulse/how-create-data-islands-qlikview-using-source-christiana-steves/

I hope it helps.