repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

command getcheckpoint response:

{

        "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

}

[getcheckpoint command] Succeeded

Regards

Dipankar

Hi,

I'd like to replace in my script some nested previous used to find the last value for a field (in this case, the supply source) in a table that have values similar to:

Tab:
Load *,
If(len(trim(Source2))= 0 or Source2='NULL' or Source2='-', Null(), Source2 ) as Source
INLINE [Trip Stop Type Source2 Pickup Delivered
a1 1 1 a 20 -
a1 2 2 - - 11
a1 3 2 - - 6
a1 4 2 - - 2
a1 5 3 b 18 -
a1 6 2 - - 16
a1 7 4 - - 3
](delimiter is ' ');

This would be a tipical trip, in which there are 4 types of Stops: 1 for initial product pickup, 2 for delivery to customers, 3 for others product pickup (e.g. in a provider) and 4 for product returned to plant.

I need to identify the source for each stop (that would be the previous source untill the truck stop in a provider, changing the source, type 3) and I solve this situation by using nested "previous" function as follow. Could you help me to simplify this scrip? (maybe with peek function or using other one).

My initial solution was:

Hello,
Is it possible to do cell sorting by color in qlikView?

I have such data and I would like to sort in such a way that records must be colored first.

Please help!!!

Hi All,

I am working on VizLib replacement for one of my Qlik Dashboard. In the dashboard one of the sheet have VizLib Filter pane chart in which Dimension has taken CNSelect, and in conditional filtering =IF(ONLY({1} CNOrder)<13,True(),False()) expression has applied
in 2nd filter pane =IF(ONLY({1} CNOrder)<25 AND ONLY({1} CNOrder)>12,True(),False()) this expression has applied

2 filter panes has formed . I have selected value from 1st Filter pane and also value from 2nd filter pane, so it has not removed value from 1st filter pane when selected value from 2nd filter pane.

I need to implement exactly same with native Filter pane object in frontend only

Please help, it would be so helpful when someone solves this

Thanks!!

Dear Community 🙂

Here the "challenge":

I want to link a table that has three fields: "Product ID", "Supplier No" and "is_DefaultSupplier" as this table shows the Default Supplier every product with the Supplier No.

In the DataModel (attached), I have a table "ProductDim" with the field "Product ID" and a table "Supplier" with "Supplier No". 

How can I link my new table? 🙂 Do I have to go via the LinkTable?

Thanks a lot and greetings from Switzerland!

Pesche

Qlik have introduced the Cyclic group to Qlik Sense Cloud, Which is a fantastic addition for you to dynamically change the dimension based on the cyclic group.. This opens the doors to dynamically use the the Cyclic group in Aggregation function in a calculation.

• Create a Cyclic group with the required Dimension values . EG Locations.
• Create a Variable in the script to get the label of the group dimension created above (Note the single quotes and the = inside , very important for the $ expand to compute the values from the cyclic field name selected

set vLocations = '=GroupDimensionLabel(Locations)';

• Use the variable inside your formula

Aggr(Rank(1-count({<[somefield]={'somevalue'}>}some_number)/count(some_number)),$(vLocations))