Hey there,

I have a table in my app that contains a few dimensions and 3 measures.

The 3 measures are:

1. Current Period - Represents the amount of money I currently have (based on period selection)

2. Compared Period - Represents the amount of money I had in a selected period (also based on period selection, using a different variable than the one used in current period)

3. Difference -  the calculation of money in my current period minus the money in the compared period

Also, I have a variable that gets a number that is used as a threshold for amounts of money (we'll call it $Threshhold).

I'm trying to filter rows from the table based on the next condition:

If the absolute value of the difference between the periods is greater than $Threshold, then keep the value of it in the table, otherwise filter it.

The problem is that I can't find a way to actually filter the values from the table, the become a null value instead.

I tried many IF conditions and also tried using the limitation option in one of the dimensions, but to no avail.

I would really appreciate if someone could help me with this.

(And sorry I cant ease it with real examples).

Thanks!

Hello, 

I am using Qlik Cloud and leveraging a large dataset in BigQuery. I have setup up direct query successfully to start building analytics. 

I am facing an issue with the Fractile function. I need to generate 99%, 99.9% quantiles and the direct query seems to only support basic aggregation functions.

I have tried to define a Fractile measure. Qlik is accepting the expression and then generating SQL with the Fractile function in BigQuery. BigQuery computes quantiles thanks to different functions but Fractile() is not one of them. 

The trick is that Fractile cannot be preaggregated. It needs to run on the full dataset.

Is there a workaround I could apply?

Thanks

Hello everyone!!

I am a newbie and have little info aboutapp development. I wants to develop sim registration app. Can I do so on the behalf of my knowledge as a newbie. Or should I hire a freelance developer.

If yes then tell me the quielties of the developer that are suitable to hire

When extracting data from a MySQL table to a QVD file, most timestamp values are saved as NULL.

It is a simple script:

LIB CONNECT TO 'MySQL_MYDB (qs.user)';

LET vTabla = 'MY_TABLE';

$(vTabla):
SELECT *
FROM my_schema.my_table;

STORE $(vTabla) INTO [lib://DAT_MARIADB_MYDB_QVD (qliksense_user)/DAT_01_MARIADB_MYDB_$(vTabla).qvd] (QVD);
DROP TABLE $(vTabla);

When querying the database directly, there are no NULL or invalid values in the timestamp column. However, QVD metadata shows 95% NULLS (using QViewer):

As a result, every date related KPI is not reliable, since data is not consistent with the source.

What can I do to prevent this?

Bonjour,

J'essaye désespérément de récupérer certaines infos du CRM Sellsy grace à leur API (https://api.sellsy.com/doc/v2/) mais je bloque sur le filtrage des données !

Dans ma requête, j'utilise la clause "With connection" suivante : 

WITH CONNECTION (
URL "https://api.sellsy.com/v2/activities/search",
HTTPHEADER "Authorization" "Bearer $(vAuthorization)",
BODY "$(vBody)"
);

vAuthorization, c'est le token que je récupére pour autoriser la connexion, aucun souci.

Et vBody, c'est ca : 

Let vBody ='{""filters"":""entities"":[""calendar_event""]}';

Je precise que j'ai utilisé plusieurs modèles pour le vBody

Exemple : '{[""filters"": {""entities"": [""calendar_event""]}]}';

Et malgré ca, le filtre ne fonctionne pas du tout !

Ca ne renvoi pas d'erreur, mais ca ne filtre pas !

J'ai testé dans le requeteur Postman, et ca fonctionne très bien !

En espérant que quelqu'un ai déjà utilisé ce type de connexion !

Merci d'avance !

Hi I have data loaded as NUM. It contains date. I want to convert it to date format so that I can load it into the datepicker.

Here is my data:-

I have tried these in the data load editor:-

Load

Date((Floor(Timestamp#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];

Date((Floor(Num#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];

I have set my date and time to this:

SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';

It still loads as Num. Can anyone suggest how to load it in Date?