topic Re: Different values when using Section Access in QlikView

Different values when using Section Access

pacoli2013 — Tue, 07 Feb 2017 10:21:35 GMT

Hello,

Can someone explain me the following:

I have a QVW without Section Access and Section Application (QVW01) and one with Section Access and Section Application (QVW02), the rest of the script is exactly the same.

The Access tab in QVW02 is very simple:

Star is '-1';

SECTION Access;

// ad 01. Allow access for QADMIN: QADMIN / SUPER ADMIN
LOAD * INLINE [
ACCESS, USERNAME, PASSWORD, SALESDISTRICT, CUSTOMER
ADMIN, QADMIN, QADMIN, ALL, ALL
];

// ad 02. Allow access for users :USERS / PASSWORD
//LOAD
//          if (ALLDIMENSIONVALUESALLOWED = '-1', 'ADMIN', 'USER') as ACCESS,
//          USERNAME,
//          PASSWORD,
//          SALESDISTRICT,
//          CUSTOMER
//FROM [$(DataPathQvd)PrimDef_ReportingUserDimValueAllowed.qvd] (qvd);
//

SECTION Application;

So nothing special.

But there is a difference between QVW01 and QVW02 which I cannot explain. This is to been seen in the worksheet Dashboard SalesInvoice. This worksheet has a Gauge with Actual (year) versus Actual (previous year) and a table with some values and calculations. The gauges and the tables are also in both QVW’s the same. In fact I made a copy from QVW01 (QlikTech Question) and built in the section access tab and called it QlikTech Question with Access.

When you select year 2015 both Gauges show 102,91%, when you select 2017 the percentage is 8,15%. When you select 2016 the gauge in QVW01 shows 108,60% and in QVW02 36710526,67%

Selection	with Access	without Access
2015	102,91	102,91
2016	36710526,07	108,6
2017	8,15	8,15

The Table below the Gauge shows the right percentages in the right column (% Difference This Year versus Last Year) and the pointers of the gauges shows the correct percentages.

So can someone explain me why the values in 2015 and 2017 are the same but not in 2016. When the values for every year were different I could imagine that there could be a filter on the actual amounts, caused by the section access.

But this only in-one-year difference I cannot explain. So I hope someone can (have added both QVW's)

In QVW02 I’m logged in with QADMIN

Thanks in advance

Regards

Court

Re: Different values when using Section Access

avinashelite — Tue, 07 Feb 2017 10:35:05 GMT

Do you have null values in the data ??

Re: Different values when using Section Access

pacoli2013 — Tue, 07 Feb 2017 13:54:20 GMT

No,

I have two kind of amounts: Actual or Budget. And one of them is always greater NULL()

Re: Different values when using Section Access

avinashelite — Wed, 08 Feb 2017 05:47:33 GMT

I checked your file ...in the section access file you have 1 or more extra records because of which you have this difference

add the ActualAmount , Year and other required columns . You could see some additional Columns in the Section access file

Hope this helps you

Re: Different values when using Section Access

pacoli2013 — Mon, 13 Feb 2017 08:11:02 GMT

Thanks,

I will add the columns and test it

Re: Different values when using Section Access

pacoli2013 — Mon, 20 Feb 2017 07:15:20 GMT

Hello

I have added some columns and made the Access tab hidden: Problem solved

Re: Different values when using Section Access

avinashelite — Mon, 20 Feb 2017 07:28:26 GMT

Cool ..if you have got the answers mark the helpful and correct answers and close this thread