From time to time, we have issues with Replication and miss records from the source.  Full Replication load of the ODS from the source solves that problem, yet the DW/DM are still missing the records without some additional actions.

We typically run the DW in incremental load from the CT tables, so the missing replicated records never get into the CT tables and thus never get into the DW. 

I've run a full load (without drop/recreate) but that doesn't pick up the records, which is somewhat confusing to me.

Are there any tricks to reloading missing records?

I could write code to 'touch' the missing records in the source and trigger replication to CT tables, but that seems awkward, but certainly will work.

I know I can brute force the issue by doing a full drop/recreate/full load of the DW and the DM's, but that has its own set of issues.

Ideally, I'd like to only drop/recreate/full load only a few tables that are missing records, vs having to reload the entire DW.

Any help would be appreciated.

ron

Hi, please let me know about this extension if someone has used before or anything similar probably freely available.

First one options filters like a pop up option, and for second one there is buttons under the table to view more data instead of scrollbar. And there is pivot table which shows total underneath the last row.

Do let me know about this particular navigation menu.

Regards

Hey guys, just wondering which technical doc tools you use for Qlik Sense to record which would be able to record what variables etc. Exist on our visualisations. The idea would be to auto generate a doc for report preparers or stakeholders to get an understanding of what they are lies just underneath what they are looking at and how the number was generated.

Any ideas on what is possible here?

Hello Experts,

I'm trying to use the dates in my KPI to count material. For example, the expression below works well when I want to count material between dates. The problem is that every time I refresh the data, I have to change the date in the expression.

Count({<[Dta Receive]={">=$(='4/30/2021')<=$(='7/21/2021')"}>} COG)

I have several KPI's with this expression "Sum(Aggr(Sum(distinct{<Phase={'Induction'}>} Date([Actual Start Date.autoCalendar.Date])), Phase))" that extract the date I want base on its phases.

I have tried using , "Count({<[Dta Receive]={">=$(=[Start of Phase 1 Date])<=$(=[End of Phase 1 Date])"}>} COG)". But no success. Does anyone know if this is possible? I appreciate any help you can provide.

Hello,

My Current Qlik version is "Qlik sense May 2022 - 14.67.7"
My Old Qlik version "Qlik sense February 2021 Patch 2 - 14.5.7 "

The Issue / Bug

I have multi-page mashup. When any selection(s) are done in one page, it doesn't follow through on another page. Also being same application. But when application or Mashup editor is open selection works fine.

This issue has started after the upgrade.

Please let me know if anyone having similar issue and found the solution

Hi,

I'm trying to do a drop and recreate all tables in Compose but the option is grayed out. We had a production failure on the backend and I'm trying to reload the tables using Compose.

Thanks,

Jessica S.

Hi all,

I have a sales data, This data is seeing different people for different regions,

When US people open the dashboard it shows the sales as Doller format

When UK people open the dashboard it Pound format,

IND people open the dashboard shows INR format.

For eg: one user is there in US today that person the open the dashboard it shows the Doller in money, That person moving to UK and Open the dashboard in UK location, it shows the UK money format in this way...

Thanks 

Ram

what is sub function?

what is the applications of sub function?

what is the procedure to implement it?

please provide different examples  to understand this function?