Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

meitargold
New Contributor III

Dim data not exists in FACT

Hi,

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.


ThanksCommunity.png

Tags (2)
1 Reply
felipedl
Valued Contributor III

Re: Dim data not exists in FACT

Hi Meitar,

You could try an if statement to check if the Company has value, something like this

if

(

  len(Company) <> 0,

  count(Item)

)

Attached is an example QVW.

Regards,


Felipe.