topic Re: Diference in script and UI in QlikView

Diference in script and UI

Anonymous — Wed, 11 Mar 2015 04:39:47 GMT

Hi,

I found the functions working diffrently from scipr and to UI level.

I am attaching the source and sample app

kindly have a look at it.

tresB — Wed, 11 Mar 2015 04:50:41 GMT

The equivalent script would be like:

Temp:

LOAD

// SaleId,
Count( DISTINCT SaleId) as NewSalesID
Resident CountTest where Region='Ind' Group By Region ;

PFA

Anonymous — Wed, 11 Mar 2015 05:51:30 GMT

Hi Tresesco,

thanks for the reply.

I would not like to restrict the region Ind in script itself, the check may vary .

So, could you please check with out the Ind selction?

Wed, 11 Mar 2015 06:26:50 GMT

Hi John,

just note that in load script and in UI you try to do count on different level.

This is the reason why you have different result.

tresB — Wed, 11 Mar 2015 07:25:00 GMT

Then remove the WHERE clause like:

LOAD

Count( DISTINCT SaleId) as NewSalesID
Resident CountTest Group By Region ;

Now take Region as dimension in a chart and check the result.

Anonymous — Thu, 12 Mar 2015 04:05:34 GMT

Hi,

Taras please find the below attachment, where i have taken the correct comparison.

still could not yield the desired result.

rwunderlich — Thu, 12 Mar 2015 04:36:54 GMT

You are not doing the same calc in script as the UI.

In the script you are counting DISTINCT SalesID grouped by SalesID. Which can never equal anything other than 1.

In the UI, you are counting DISTINCT SalesID grouped by Region (your Dimension).

Perhaps you could explain the business problem you are trying to compute.

-Rob