I have a run a script and stored the table into a QVD.
It has following fields
When I open the qvd and try to find the number of Server using text obejct --- count(Server) it gives me 4469. But when I create a table obejct with the dimensions Server , Storage and field1 and import that into excel , I can see there are infact only 4417 servers.
When I chechked the Storage using both text obejct and excel method, again isame thing happens. Text object shows 4.6 terabytes and when i do sum(Storage) on excel shows 4.3 terabytes.
What am i missing here?. The storage is 4.3 terabytes after validating with the team but why does qlik skew up the values?.
Your data could well have values missing or duplicated that cause these results, to get a feel for your data try creating Statistic Boxes for the fields in question with all the ... count functions displayed.
Also see if count(Server) gives the same or different value as count( distinct Server) .