Discussion Board for collaboration on QlikView Layout & Visualizations.
1. I have Items Dimenssion and Companies Dimensions.
2. My Expression is 1.
I think because I have no data in the FACT table about the Item name "Ki Net Profit",
I see the 1 amount (from the expression) under null Company.
Any suggestion to solve that?
* When I put data for this item in the FACT I see 1 under the companies Dim, But I want another solution if exist.
* I need a layout solution only.
You could try an if statement to check if the Company has value, something like this
len(Company) <> 0,
Attached is an example QVW.