All Forums

I have a security rule with name 'ReadOnlyAccess' and

resource filter: App.Object_*

Actions: Read

Context: Hub

below are the conditions:-

((user.roles="ReadOnlyAccess")) and !resource.App.stream.Empty() and resource.App.HasPrivilage("read") and (resource.objectType="dimension" or resource.objectType="measure")

Below is what we need to achieve: 

User should be able to see load editor - Read only view
User should be able to see Data connection view - Read only view
User should be able to see all streams - Read only view
User should be able to see all apps inside stream - Read only view

I want to add color to the bar graph by entering the Expression background color.

The conditions are If the bar graph shows data for the year, include rgb(30,144,255) and if the graph shows data for the month, enter Rgb(70,130,180) and if the graph shows data for the day, enter rgb(135,206,250)

This is the code that displays the data in a bar graph.

please help me

In the NPrinting Repository Database, I am trying to find where I associate which data connections a NPrinting report is utilizing. 

The entities_xml field looks to have the data connection inside but it is not for all my reports. 

Wondering if it is in another table besides report,task,data conneciton. 

Hello, 

I currently have a button that I have actions set up against it. 

In the Action button I have a field that is selected. 

Inside of the Expression editor in the field, I am trying to pull these values:

"(6010015 - Penguin Random House LLC|6010030 - HarperCollins Publishers|6010031 - Macmillan Publishing USA|6010033 - Hachette Book Group USA|6010036 - Simon Schuster)"

What is the proper syntax for using text/numbers? I used this before: "(6010030|6010033|6010015|6010031|6010036)" and this worked perfect. 

Any help will is appreciated. 

All,

I am looking to update the document title bar in QlikView desktop. I would like to remove the QlikView icon, QlikView Text, and the document title entirely. I can settle for leaving the QlikView icon and version text, but I cannot display the document title.

Under the document properties, you can update the document title. However when the document title is set to a null value, the path of the document is shown. Also, placing an empty string will display "[ *]" in the title bar.

Is there a way to update the title to accomplish any of the below layouts?

Preferred Displays

Hi,
I want to load the data from two different SharePoint links.

1. one link opens direct excel file data with no of columns.

2. Second link opens JIRA Details with no of columns directly (we don't want left side and top names ), we want to load the columns into qliksense  which are highlighted in yellow

Request you to please let me know the solution and process with more details how to load the data from Share point link, as tried to load through WEB file by putting those URL links but not working.

Base on diagram I will like to acquire Access token for my client app.

I saw that one of supported grant type is "urn:ietf:params:oauth:grant-type:token-exchange".

Short explanation:

• Client App is registered in External Id Provider (Resource A)
• Qlik Saas Cloud is registered in External Id Provider (Resource B)
• Qlik Saas Cloud have OAuth client setup.
• As User login in Client App, App creates request for getting access token with scope for impersonating user on B (is it passible?)
• Then Client App requests Exchange token (RFC 8693 ) for access token of Qlik Saas Cloud through OAuth client.
• Then Client App can use access token of Qlik Saas Cloud  to connect to Enigma API.

Is this flow passible? 

Hello,

Can someone please help me with the following:

i am trying to utilize a mashup inside an iframe but i keep getting the below error from the browser console

has someone encountered it before?

Hope anyone can help me

thank you,

We are a Qlik Sense Enterprise site and are interested in giving secure access an external customer access to a specific sheet.  They do not have Qlik Sense.   Ideally, they would like read-write access to the sheet. 

Here are some older links that discuss this scenario:
-Share QlikSense app with non users - Qlik Community - 1578514
QlikSense App Share with non Qlik user - Qlik Community - 1366969 

They would need to access via the Hub and would need to use a token. You could create them as a user and assign them a login token instead of a named user if they are not going to be accessing the app often.

Otherwise you would need to use the Cloud. But you would have to export the app from the QMC and then upload it to the Cloud and then publish it there. Kind of a pain. Also, no way to reload the data in the free Cloud. You would have to repeat this process every time you reloaded the app on the server.

Keep in mind that they don't need Qlik to access the app. They just need access to the URL for your hub using their browser. But once they access an app they are technically a Qlik user.

This is sensitive information and not to be consumed by the public. 

Questions:
-What has changed since these posts were written? 
-Has anyone done this successfully?  If so, how did you set it up?   There was mention of giving the external user access to the sheet's url .
-Were any additional Qlik products needed?  One post mentions that the external user needs Qlik Capacity Analyzer, and there was mention of Qlik  Cloud - is that now Qlik Enterprise? 

Thanks for any info you can give!

Hi,

what i want is load a excel file from my device to qlik sense and connect to API with Rest connector(this part is ok, i create Rest connection), get analyze data from it. for example ask some question and get response from chatGPT

can anyone guide me please

Hello, 

I will need to filter the Actions based on my cursor positon within the Statustable. E.g if I click a date within column TOSV34 the table below supposed to only show Action 34, in case I click within column TOSV100 respectively only action 100. 

Best Regards 

Timo 

We have some connections to DataRobot from our Qlik Cloud tenant that perform live predictions when certain sliders and drop-downs are changed, creating new values to drive the prediction.

I recently went to review how this had been created so that I could replicate it for a customer demo, and I found that it is no longer possible to save a connection with the fields specified that should be used from the response. Whenever the tick box "Load all available fields" is deselected, the option to test or save a connection is unavailable. 

Has anyone else noticed this change? Has the way that the connection is defined changed? The connection is returning predictions when the same connection definition is used in batch, but when I then try to use that endpoint in the chart expression, zero is returned in the chart, which looks like field[0] in the response. 

Anyone got this working better than me and able to pull back a specific field in the response?

Hello,

the distribution and publishung of qvw files is very slow.

We have 2 servers, a reload server and a server working as accesspoint. 

The storage where the files are copied are nfs (SSD).

Publishing qvw files direct to the publisher to local disc is also slow (SSD).

Publishing to a normal folder is fast.

CPU and RAM are not the problems, there are always enough free ressources.

in the Task logs we found this:

(28.11.2023 17:50:01) Information: <Global method="FileWrite"><h>0</h><Pos>83886080</Pos><Buffer /></Global>

(28.11.2023 17:50:01) Information: ExecuteWithAttachments returned no data in buffer.

(28.11.2023 17:50:01) Information: <Global></Global>

The support already checked all logfiles of the operating system and the qlikview server but there were no irregular and suspicious entries.

the following tips of the support are not working or brought no improvement:

https://community.qlik.com/t5/Official-Support-Articles/Scaling-the-QlikView-Publisher/ta-p/1717686

https://community.qlik.com/t5/Official-Support-Articles/QlikView-and-its-backend-File-Share-System/ta-p/1713428

https://community.qlik.com/t5/Official-Support-Articles/QlikView-Tasks-and-reloads-do-not-trigger-are-queued-or-give/ta-p/1710798

We use the publisher in Version12.80.20000.0 on the reload server.

What could be the reason for slow distribution and are there some hints to solve this problem?

Thank you.

We just cloned our server, we cloned the production one, to make it the qlik approval server, our problem is that now we cannot access qlik on this clone via browser, possibly for the reason that the localhost and ip changed, I would like to know What should we adjust to be able to access the qmc of the clone that became homologated, with a new path.