I am trying to pull my companies fixed assets and it is extremely over stated.  First issue is it is doubling up assets for multiple countries USA and Canada.  I have added AffiliateCode = 77048 to the Where clause and that seems to have fixed that issue but our fiscal year ends in 03/31/YY. Before the year rolled over this wasn't an issue.  

The 2nd issue is there are 2 record dates on some assets and I am trying to pull the newest date only.  I am trying to use FirstSortedValue with a minus weight to get the "last value".  Below is the code I am using.  What am I doing wrong?

I have a load script that had dash or -. I want to exclude them from the load script. I know I can do it within the app, but I like to do it on the load script.

Len(Trim(Category))=’-‘ works, but I need the opposite     Len(Trim(Category))<>'-' The opposite does not work.

Any help will be great.

Qlik Connect 2024 is just around the corner, and we're thrilled to announce that AnyChart will be participating as an Emerald sponsor and exhibitor. Join us at Booth 807 from June 3–5 at Rosen Shingle Creek in Orlando!

🚀 We'll be excited to showcase how our latest developments for Qlik Sense can elevate your data analytics efforts — come see our solutions in action!

🔧 We're also eager to preview what's coming next and discuss how we can tailor our Decomposition Tree, Gantt Chart, Sunburst Chart, and other extensions to meet your specific needs — an excellent opportunity for you to get tools perfectly adapted to your unique data challenges.

Visit our Qlik Connect event page for more details and to schedule a meeting with us (we'd love to prepare something especially for you).

See you at Qlik Connect, Booth 807! 

Hi,

This is our second week using talend as an organisation after training, so we are very fresh.

I am currently sending a body in trest to retrieve a token. 

This is my setup

This is my tmap. The response is a string and not json for some unknown reason so textractjson didn't work.

I get that token successfully in this format. 

How does one put that string value into a variable? 

Regards,

Ryan

I am trying to do section access for only a specific user but all other users with access to the app I would like to grant full access. Is there a simple way of doing this without managing users in two places?

Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the button has been selected instead of looking in the filters. Does this exists?

For instance, I have the white button here that is not selected but when it does, it has to become grey.

 

 

Thanks to all of you for your help!

Hello,

I am trying to input more than one string in a variable and the best I could come with is this...

I am running out of ideas as to why this URL request is throwing the 415 error. We have Talend Data Catalog and I am requesting the endpoint to logout the authentication that is currently logged in. I tested this request using the Data Catalog API tool and it was successful. I have the same setup as shown in the web tool in Studio, but I cannot figure out the problem. Can someone please help me? The attached document shows the request and 200 response log from the Data Catalog web tool along with the Studio request and 415 response log. Am I missing something?

Hello,

I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period in a favorite that I will create, as an example, we're in May, I want to select April.

Any expression for that please?

Hi,

I have a main table which has customers for each day for a period of 2 years. 

Example

A distinct count of customers over each day gives me the below table

Now, I have to calculate the distinct count of customers for each date over a rolling past 30-day window. 

For example, on 1-Feb-24, I need the distinct count of customers from 1-Jan-24 to 1-Feb-24. On 2-Feb-24, I need the distinct count of customers from 2-Jan-24 to 2-Feb-24. I have tried the below methods so far.

• Using the Rangesum with below function, but it aggregates the distinct count of Customers each day and sums it up over the rolling period.

=rangesum(below(aggr(count(distinct Customer),Date),0,30))

The problem with this is there will be duplicates across the 30 day period and the above formula adds them all up. 

• Hard code the dates like below but it takes the overall table's max date so the count is common across dates.

count(TOTAL DISTINCT{<Date={">=$(=date(max(Date)-30))<=$(=max(Date))"}>} Customer)

• Rangecount doesn't seem to work either. It returns '30' for all dates.

rangecount(below(aggr(count(distinct Customer),date),0,30))

I would really appreciate any help that would help solve this issue.

Thank you very much.