Dear Members, 

I am trying to build one logic from excel to Qlik Sense Cloud. But after several efforts it's not working as expected. So need your help. I have attached test data. This has three data sheets for Aug'19. 

1. Orders - these are orders created in one month.  

2. Activities - these are activity closed in same month. 

3. Orders_2mths - these are last two months orders data. It's a reference sheet for activities table. Activities pick IN_OUT & Country field from this sheet. 

Now I am trying to build some charts based on above data. one of example is given in chart sheet. This is using Orders & Activities sheets only. 

There will be two charts one for country & other for months. Country chart will show only latest month data and Months chart will show monthly trend and added month bars as year passes. 

Now challenge is , if we connect Orders & Activities on basis of Order_No & Month. We lost few orders due to this mapping. If we add them only using Order_No, we didn't get monthly chart.

Country is available in both Orders & Activities. But we need to use order's Country_O for chart preparation as it's in denominator of ratio. 

Please share your thoughts to build this logic. 

Test Data

Hello together,

I'm wondering if it would be possible to make a whole dashboard sheet with defined selections available as a snapshot to be used within the story telling function of Qlik Sense.

Live dashboard can't be used since we (our customer) want's to have the same dashbord with different selections available in the story.

Example:

Timeline Page 1: Sheet 1 with selection April

Timeline Page 2: Sheet 1 with selection May

a.s.o.

Of course it would be possible to to make snapshots of every single dashboard sheet item - but that's a lot of work, if you have to repeat these steps for mulitple selections from the same sheet.

Any ideas?

Best regards,

Markus

Hi All,

I am trying to load multiple excel files from SharePoint using FileList but didn't get through could you please suggest how can i load all the excel files from sharepoint,or please suggest if any workaround for this.

Please find the below code which i am using to read the files

Ex:

for Each file in FileList('https:\\SharePointlink\*.xlsx');

LOAD

  FileName('$(file)') as DocName

FROM

[$(file)]

(ooxml, embedded labels, table is Raw);

NEXT file

Thanks & Regards

Mallikarjuna

Certification candidates may now register and take the three new Qlik Sense Certification Exams based on the June 2018 Release. The roles for the new exams are Business Analyst, Data Architect, and System Administrator. Each exam has 50 questions to complete in 2 hours.

There is also a new Certification FAQ and Qlik Sense Certification Exam Study Guide on qlik.com

Partners holding any Qlik Sense – v3, v2, or v1 certifications should update with these exams in 2019, in order to meet the requirements for the Qlik Partner Program.

All previous versions of the Qlik Sense Certification Exams have been retired. Candidates who have a June 2017 exam scheduled may still take it, but are encouraged to cancel and reschedule their appointment with the latest exam.

All Qlik Certification Exams are in English. Candidates who have difficulty because English is not their native language may request an accommodation (extra time) on the exam by emailing certification@qlik.com at least 10 days before they want to take their exam. Each individual must make a request for this exception and they should include their VUE ID, found in the Personal Information page in Qlik CertTracker when submitting their request.

A note about exam releases
The new Qlik Sense Certification Exams are based on the June 2018 Release of Qlik Sense. Our exams lag behind the product release, because they take 6 to 8 months to develop. We will only release new exams once per year, so the next exams are planned to be based on the June 2019 Release of Qlik Sense.
Questions?
Contact certification@qlik.com

When pressing edit message in a forum thread I'm not able to see the images added to the message.  

When I press edit reply to this post: https://community.qlik.com/t5/New-to-QlikView/Straight-Table-Data-Filter-Issue/m-p/1624115/highlight/true#M380748. Notice the dupliate images in my post. The missing images caused me to add it again during the edit and now it is impossible to remove any of them.

I see the following in the edit pane:

Good afternoon,

I've converted a project on Qlik Sense Converter, but all my set analysis are returning value 0. They're working normally on Qlik View.

Is there any difference between Qlik View and Qlik Sense set analysis?

Thanks.