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!!!

I made a measure for taking into account the efficiency of certain producers 

(
	Sum(
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)
/
(
	Count( 
    	distinct WorkingDay) 
        * 7.5 * 60)

And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do: 

(
	Sum( {<Employee=>}
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)

/

(
	Count( {<Employee=>}
    	distinct WorkingDay) 
        * 7.5 * 60)

But this doesn't work, and gives me null values. How could I fix this? 

Hello Qlik Experts,

I am trying to create a pivot table in Qlik that shows "Current Sales" and "Previous Month Sales" for each "month year" selected.

However, I'm encountering issues with the accuracy of the figures for the previous month's sales, and I also need the pivot table to dynamically update based on multiple "month year" selections.

Data Structure:

Here is how my data is structured:

Measure for Sum of Amount for Selected Month

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(Max(SalesDate)))<=$(=MonthEnd(Max(SalesDate)))"}>} Amount)

Measure for Sum of Amount for Selected Previous Month 

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(AddMonths(Max(SalesDate), -1)))<=$(=MonthEnd(AddMonths(Max(SalesDate), -1)))"}>} Amount)

Attached is the QVF. 

Thank you very much for your assistance!

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:

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