Welcome to Qlik Community

I want to concat the tables. so I use this script but it doesn't work

I am sharing the errow below. how can I work on this?

thanks

FOR i = 0 to NoOfTables()
TableList:
LOAD TableName($(i)) as Tablename AUTOGENERATE 1
WHERE WildMatch(TableName($(i)), 'ZCS_BOM_EXPL_MAT_V2*');
NEXT i

FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));
Concatenate (ZCS_BOM_EXPL_MAT_V2)
LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
NEXT i;

DROP TABLE TableList;

This article gives an overview of the available blocks in the Zendesk connector in Qlik Application Automation. It will also go over some basic examples of retrieving tickets and creating a ticket within a Zendesk account.

This connector supports CRUD operations(read, create, update, delete) for the following modules in Zendesk:

• tickets
• contacts
• organizations

There are also a few blocks for managing file uploads and linking those to a ticket comment.

Authentication for this connector is based on the oAuth2 Protocol. For more details check this article.

Let's now go over a few basic examples of how to use the Zendesk connector:

1. How to list tickets from a Zendesk account:

1. Create an automation;
2. From the left menu, select the Zendesk connector;
   
3. Use the 'Search for blocks' input to search for the "list tickets' block;
   
4. Drag and drop the block into the automation and link it to the start block;
   
5. From the left menu, search for the 'Output' block;
   
6. Drag and drop the 'output' block into the automation and link it to the 'List tickets' block;
   
7. Run the automation (if not saved previously, a 'Save automation' popup will appear). This will output a paginated list of tickets available.

2. How to create a ticket in your Zendesk account:

1. The first two steps are similar as before;
2. Use the 'Search for blocks' input to search for the "Create ticket' block;
3. Drag and drop the block into the automation and link it to the start block;
   
4. On the right side of the screen, use the input fields to fill in the ticket information;
   
5. Run the automation (if not saved previously, a 'Save automation' popup will appear). This will create a new ticket in your Zendesk account and output this information.

3. For other more complex use-cases (example: Understanding how the incremental blocks work, how to upload a file and link it to a ticket) check out these articles:

• How to use Zendesk incremental blocks;
• How to attach files to a ticket comment in Zendesk.

Hello everyone,

Since 2 days I try to figure out my problem but i can not :(!

I have this data :

Date- Account -  family - amount

01/01/2021 - 001 - 1 - 100

01/01/2021 - 001 - 2 - 200

01/01/2021 - 001 - 3 - 200

01/02/2021 - 002 - 4 - 500

01/02/2021 - 002 - 5- 500

I want this result : 

 Account - Family - Number of family - Total amount of the family

 001 - 1-  3 -  500

 001 - 2-  3 -  500

 001 - 3-  3 -  500

 002 - 4-  2 -  1000

 002 - 5-  2 -  1000

I try with sum(aggr(   COUNT(  distinct family ),account)) but with no success.

If someone can help me , thank you so much.

I put account and family with dimension.

I have data set  as below.

I want to display this data in a straight table with fields  Name, Description and Completion Date only with below conditions.

When no filter is selected on the filter pane, I want the table to display only records where workstream = W1 and Reporting Date = latest Date. When a filter is selected on the table all records of that Workstream and Reporting Date must be displayed. Could you please let me know how I can achieve this using set expressions. I am confused on how to apply set expression on a dimension only table.

The output should look like below when no filters are selected on filter pane. Thanks

hi all

in my app I have ~100 fields , I am not sure all of them are in use.

is there a way to indicate which fields are in use within an app objects ?

advanced thanks

Hi,
I'd like to add a google SSO using Auth0 to my SaaS  tenant portal: Qlik Sense SaaS Enterprise Version (NFR).

If I select the "Identity Provider" menu option I can only see the alert:

We are using ODAG to mask data for few fields in our Qlik Sense dashboard. Data for those fields are encrypted based on users' entitlements.

I need to do a report in NPrinting using one of the tables with masked data.   Do I need to create a separate application for each user in this case? 

Please suggest any possible solutions .  Appreciate all your help.

Thanks.