Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
enricocamerin
Creator
Creator

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

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Does the number of rows in the fact table change?

-Rob

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
enricocamerin
Creator
Creator
Author

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