Good morning,

I have following problem with restricting access to data for users - I have a database containing sales volumen in the branches and for single employees (Akquisitors)
The goal of this report is to show on 2 charts to each employee (identified by NTNAME in SECTION ACCESS) total sales volume of each branch and his own (employee's) sales volume. Employee cannot see sales volume of his colleagues, only specified users (like branch directors) can do that.

To be honest I don't know how to define SECTION ACCESS or maybe i need to change the data model?

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, ACQUISITOR_NO, BRANCHID
USER,AT\123025236,*,*
];

SECTION APPLICATION;

ACQUISTOR:
LOAD * INLINE [
ACQUISITOR_NO, Name, BRANCHID
18291, Name1, 1
11555, Name2, 1
11236, Name3, 2
14214, Name4, 3
18712, Name5, 2
];

BRANCH:
LOAD * INLINE [
BRANCHID, BranchName
1, Branch1
2, Branch2
3, Branch3
];

SALES:
LOAD * INLINE [
ACQUISITOR_NO, Vol
18291, 10000
11555, 2500
11236, 12000
14214, 7800
18712, 5600
];

Many thanks in advance for your help.
Best regards

Hello Community,

I need your help with the following topic. 
I have an excel table with the columns below: 

project / status / date 

For each project it is possible to change the status more then once a month. 
At the end of each month I want to know the latest project status of the month. (E.g. at the 01.02 project status was 'nok' but it changed on 20.02 to 'ok') 
If I use the count function in the table chart I can see both project status in February. Instead I only want to see the 'ok' status. 

Have you any advice how to handle? 

Thanks in advance! 
Rebecca

Hi Expert,

Here's my question and if I explain not properly, please don't hesitate to indicate me.

I have Account Receivable data set, which has several fields. Two of them called "Accounting Date" and "Clearing Date".

I would like to create a bar chart, the x axis would be Statistical Year Month, which is not included in the AR data set.

And the value should be filter and accumulated by Statistical Year Month, for example,

If the statistical year month is 2019/3 , and the formula  should be "Accounting Date"<= 2019/3/31 and "Clearing Date">2019/3/31.

However, I've tried below expression in bar chart and it doesn't work well. Is there anyone could give me some instruction?

Expression:

sum({<[Accounting Date]={"<=Date"}, [Clearing Date]={">Date"}>}AR balance Amount)

Note:

I generate a "StatDate" table contain three fields which is Date, Year , Month for bar chart X axis (Statistical Year Month).

Hi, I have a line chart in NPrinting in pixel perfect and I would like the start point of the Y axis to be adjustable to the data and not to start always in the 0 position.

Is there any option in NPrinting to adjust the start of the Y axis based on the existing data and not to start at 0?

Thank you.

Best regards.

Hi

with NP16 I import recipients with different settings - but I can´t find setting for the notification of a recipient.

This is always set to: "Replace groups e-mail addresses with these e-mail addresses"

I would like to set it to: "Send reports to these e-mail addresses in addition to groups e-mail addresses"

Thanks for help

Michael

Hi,

Need advice. 😞

There were some changes with the certificates and we ran into some trouble. Our solution was to completely re-install the server. Now I want to re-import the apps but I get following message:

In the log file I find this message: Bad Request [400]:Bad Request() (HTTP code: 500)

I found this information, but I don't this this will be the case for us:

https://help.qlik.com/en-US/sense/April2019/Subsystems/ManagementConsole/Content/Sense_QMC/troubleshooting-managing-QMC.htm#anchor-1

Anything that I can try? Any help is very welcome.

If more information is needed, please ask.

Best regards,

Ramzi

Hi all,

After much trouble-shooting, we were able to get the on-demand extension (available on the qlik branch) working for qlik nprinting in our qlik sense instance.  It was pretty nifty for a day or so- then something changed so that when any user clicks a button in the qlik sense report to download, it now loads (as it did before), but does not show a download arrow button to then download the generated report (SEE SCREENSHOT IN ATTACHMENT).

The only things I'm able to narrow down that changed are:

1. Gave the user role more permissions (to make sure my new users could actually download the file without having developer access)

2. Added about 15 additional user accounts with the updated user role

I can't find record of the original user role permissions to reset the user role too, and I've disabled (though not deleted) the new user accounts in case to try to revert back to the 5-6 user accounts I had created originally that were working.  I have all the roles (admin, user, developer, newstand user), yet am facing the same download issue as my other users.

What am I missing here?  Suggestions on what to try next?

Thanks!
Katie

my expression => Num(Sum(netamt)/Sum(Total netamt),'#,##0.0 %')

what if I want the percentage of room type to be calculated per year??

We are running in a scenario where nprinting task fails for the first time and runs successfully when we run it again.

The issue is we have Email configured based on a variable condition and due to task failure for the first time incorrect mail is triggered to users.

Is there any way we can control sending an email based on completion of nprinting task?