Hi everyone, 

I have got a problem to solve, if you've any idea please write about it, i would be appreciate.

I've a data set like table 1, if the company can not deliver all of order quantity, system will split. And make 2 new orders which have the same main order no. Like the row no 1,2,3. If still can not deliver the rest of the 2.step of no delivered order, again system split the quantity again. It can be go forever like this (: In my data set I saw 10 step split movement. 

What i need is in table 2. I need the main order in one raw and the delivered - not delivered in by columns. I thought the join the orders table by itself but i don't know the splitting count of each main order. I think I need to use something like while loop but at the same time it s not a small table, it s like 500 k rows so I need also performing thin. So thanks for now.

table 1:

table 2:

I've pulled in data in Qlik Sense (cloud) from the Google Analytics connector. I'm trying to convert the standard date [ga_dateHourMinute] field to a more eligible date format.

The current format is YearMonthDayhHourMinute, for instance: 201810250004, I would like to convert this to the standard date format 2018-10-25 00:04:00. How do I do this? Answers concerning methods in the data load script or master formula's or variables are all welcome.

Click to see screenshot: left = current date format and right = desired date format

I have two date fields.  Date discharged & date completed.  I would like to display the month of discharge (Sept) but include  the number completed (regardless of when discharged). I started with bar and line graph.  Example.  A service will be discharged in July but the date completed (of final paperwork) didn't occur until September.  If I am running the report in September I want to see the number of discharges for Sept and the number of completions in Sept (which would include the july discharge)as a comparison. Make sense?  

Hi 

I'm using Alternate State in my QV document to compare two financial periods.

I have a table with a number of expression based columns and what I want to do is to hide the alternate state column if the user has not selected any of the alternate state options by using the conditional function on the Expression.

Anyone got an idea how to do this? 

TIA

Andy

Hi

I'm trying to use the Qlik General Web Connector (May 2019) to download a file from a URL.  This worked using an older version of the connector, but I can't get the May 2019 version to work.  The connector is running as a service and is licenced.

I've selected the Request Method (GET), entered the Request URI, checked the "Is File" checkbox and entered the File Name.  I've added the folder that is in the File Name to deploy.config.  When I click on "Save Inputs and Run Table", the connector displays "Running... Making request to https://data.gov.au/data/dataset/8ab10b1f-6eac-423c-abc5-bbffc31b216c/resource/8d06d260-5b08-4d20-9d31-c4c9bd8b5bc2/download/privatehealth-01-oct-2019.zip" which is the file I am trying to download.  From there nothing else happens, it just hangs on that message until I cancel.  If I paste the URL into the browser the file is downloaded.

This does work with an older version of the connector, but that doesn't give the required script for Standard Mode.

Any suggestions?

Thanks

Hi Qlik,

Read about a document on how to use security rule for enabling the sharing of bookmarks from this article: https://community.qlik.com/t5/New-to-Qlik-Sense/Sharing-bookmarks-between-users/td-p/1540877

Am I able to get a hold of that document ?

Thanks,

Aladdin

Hi,

I am building a mashup.

I have a container which holds different objects. Is there a way I can access the active object from inside mashup java script code.

Thanks,

Jyotsna

Getting the Dreaded Nprinting Designer can't find a supported reporting template editor for the file.... error.

I have the Office Click to Run Version installed. Version 1902 (Build 11328.20420 Click-to-Run) (it's the 64 bit version)  it is installed locally also.

The screen adjustment comments have nothing to do with the error that everyone posts about.

Is it that I have the 64 bit version of MS Office, not the 32 bit?  is it because Nprinting is looking in the Program Files x86, and not Program files?

We upgraded to the latest version of Nprinting this weekend 10/19/2019   September 2019 version 19.29.3.0 hoping that would fix the issue.  It did not.

Hi Experts,

I have used file folder path similar to below as hyperlink in the dashboard chart expression.

The path used to open the folder as normal and it worked before the April 2019 upgrade.

It works on the desktop too. However, it stopped working on AccessPoint once I upgraded to April 2019 version. Does not work both on IE and on chorme.

'C:\Users\ssreeramula'

Can you please let me know what mistake I am doing.

attached is the sample QVW.

Hi,

I have a table with 4 Fields:

1- Brand

2- Product

3- Date

4- Stock

i want to create Condition task in nprinting 18 Nov, when the stock of any product from any branch on any date = 0,

Send me a report details (Brand, Product and Date).

Thank you