Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

enricocamerin
New Contributor III

When I load a dimension in the model I lose row in the fact table

Hello, when I do I simple sum  of measure in fact table I have the correct result

then when  in the script I load a dimension the sum in fact table change.

It's a simple sum of measure coming only from fact table

It's strange this behaviour because I used a load command and not join.

It behaves instead like it was a inner join

I'm using qlik sense 3.1

thanks for your help

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: When I load a dimension in the model I lose row in the fact table

Does the number of rows in the fact table change?

-Rob

Re: When I load a dimension in the model I lose row in the fact table

What you'e done in Script and same in UI. Can you post images

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
enricocamerin
New Contributor III

Re: When I load a dimension in the model I lose row in the fact table

Thanks for your answered

Since I'm quite at the beginning of the project I decided to create a new fresh app and copy and paste the script from the original APP and now the new app is working fine

Enrico