Hello everyone,
I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:

I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:

This is the expression:

=count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )

If I use the filters and select only the scenarios I want, I get the result I expect:

But, I need you to give it to me without using the filters.

I hope you can help me.
Thank you very much

Dear all,

I have table such as below  without any modification date fields and every day the period is changes based on backend calculations.

Day:1

ID        Period

1         2Yrs-3months-10days

2         4Yrs-5Months-0days

3         0Yrs-1Month-10days

Day:2

ID        Period

1         2Yrs-3months-10days

2         7Yrs-2Months-0days

3         0Yrs-1Month-11days

Our requirement is display the latest Period for each ID. How can we achieve this.

Dear all,

I have below code running in qliksense to get the profit and margin for each ID from the fact table.

I have total 300000 unique ID for each of them I am gettting profit  from database package.

Problem is it is taking too much time which is offcourse because for each single ID it is getting connected to database package which has its own script and then as function it is returning its profit to the qliksense.

I need to understand if there is any possible solution to fetch the records faster..

Fact:

LOAD 

ID 

FROM TEST.QVD;

For i=0 to fieldvaluecount('ID)'

Let vFieldIDValue =FieldValue('ID','$(i)');

Profit:

LOAD*;

Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))

NEXT;

DROP TABLE FACT;

So, in above code the highlighted is the database package and profitmargin is the function which takes single ID from fact table as parameter and do its CALCULATION AND RETURN the result as profit.

NOTE: when we execute "Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))" in database directly it takes very lesss time than the qliksense

Hello Qlik Community,

We are currently trying to replicate various tables from a DB2-ZOS to a DB2-LUW using Qlik Replicate, and we have noticed that the nullability in the target table and the corresponding __ct table are different. Are there ways to keep these consistent?

some snippets of the corresponding log:

I am relatively new to this software, and I usually replace my old data with new ones at the homepage. But my 'add new' button is gone (which is the one i usually upload data before i go into data load editor) and i dont know how it went missing. can anyone who knows about this help me out?

Hi,

My connection to Dynamodb was working a couple of days ago. When I try to connect now, I am getting an error message saying "Error connecting to the Sense service". How do I fix this please?

Thanks

Hi People,

I have installed the app Sense-Script-Load-Analyzer.qvf,

and changed the app owner - as requested.

When loading, I get the error mesage:

Connection monitor_apps_REST_app not found.

Any idea how I an resolve this?

Are there any alternatives for this tool?

Thanks!

Hello all,

I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.

= Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))

Thanks.