Welcome to Qlik Community

Hey Qlik Community,

Has anyone successfully connected to the Strava API to query data? In my spare time I do a lot of cycling and running and I upload the data from my Garmin wearable to Strava. I'd like to be able to query this information to do some analysis. If anyone has done something similar or connected to Garmin Connect I'd be very interested to see how you did this.

Thank you for all the help!

Tanner Glenn

Hi,

I have 13 years in "Years" column but i need to load only the latest 4 years in load editor.

 Years column:

i need to load:

if we are in 2022, the Years loaded should be:

and so on. Thanks

Hello all,

I need to create a filter that does not show the current period, so I want to create it on nprinting based on qlikview set analysis.

I have this data

I have tried this one but with no success:

max({<[ReportDate]={'$(=Today())'}>}PeriodPXFYX)

what measure I need to create in order to solve it.

FOR EXAMPLE: 

I need today to return the value: "P3-FY22" so after create that i can eliminate that data on the report.

Thanks for help

Ido

Qlik Sense のクラウド版のお問合せについて、共有させていただきたいケースがありますので、3月に行った　【Partner Enablement Session】Qlik Sense SaaS editions – to start Supporting 
をベースに、更新版を Qlik Sense SaaS editions – Updates との内容で、8月5日に、Partner Enablement Sessionを開催させていただきました。お忙しい中、ご参加ありがとうございました。

資料では、リンクをクリックしていただければ、該当のWebページが表示されるようになっていますので、ご活用ください。
当日、参加できなかった方もいると思いますので、ビデオもアップロードしております。
資料は、英語になっていますが、当日の説明は、日本語で行っています。

今回の資料には、3月に行った　【Partner Enablement Session】Qlik Sense SaaS editions – to start Supporting　のケース内容は、含まれていないので、初めてサポートされる方は、3月開催資料の5番、6番の項目も、ご確認ください。

In Qlik Sense for Windows it is possible to allow (or deny) for dedicated users the download of datas to Excel.

This should also be available in Qlik SaaS.

Can I found supporters for that?

Regards

hi 

I have a file name like this 

Abc-June-2021.xlsx

Now i am trying to extract Month and year like this in script 

 Trim(Replace(FileBaseName(),'MMailBoxUsage-','')) as MailBox_Date

and the output is June-2021 .. but now i want to extract Month and Year separately from MailBox_Date field .. 

how i do this ?

Hello,

is there a way to deny similiar users to export data from an explication in Qlik Sense SaaS to Excel like it is possible to set a security rule in Qlik Sense for Windows?

Thank you

Is it possible to use applypatches with path "/"? 

I have tried this:

var patch = new NxPatch() { Op = NxPatchOperationType.Replace, Path = "/", Value = "{ \"title\": \"Min rubrik\" }" };
var patches = new NxPatch[] { patch };
await genericObject.ApplyPatchesAsync(patches, true);

but it complains that my JSON has a bad format (Invalid parameters [8]:Invalid parameters(Patch value not on valid JSON format.)). My intention is not to change only the title, it is a small test. I would like to apply a whole JSON object of properties, because I find it very tedious to search for paths and values in the properties.

I have already tried this, and it works:

var patch = new NxPatch() { Op = NxPatchOperationType.Replace, Path = "/title", Value = "\"Min rubrik\"" };

so please don't give me that advice.

Hi Expert,

Need quick help:

I have table with below fields :

I want one resulting column which should be calculated as "A-B"

Kindly help.