I want create dimension for using in a tabes and in a filter pane

[mzim]

Hi everybody,

By title, you realize that I'm new in Qlik sense, so I will appreciate your help

I created  a table as below:

I created a dimension with 2 values 'On Time' and 'Off Time' and i get the correct result on the table 

I can't use it as a normal dimension to filter the results on the table or to create a master item to use in a filter pane.

Additionally to that issue, i would like to calculate 3KPI's as Below:

any help on that ?

The nain entity is Receipt (Header Info) and 1 receipt could have many Purchase orders (Header Info) and every receipt has many Items with their quantities (detail info).

i achived to create  correctly  KPI#1 and KPI#2 but i can't create KPI#2 

KPI#1 =  sum({<[ReceiptH.StatusCode]={'90'},[DocH.IsCancelled]={'No'},[DocH.AccountTypeDescription]={'ASN'}>}if([DocH.ActualPrintedDate]=[ReceiptH.InputDate],[ReceiptH.Records],0))/{<[ReceiptH.StatusCode]={'90'},[DocH.IsCancelled]={'No'},[DocH.AccountTypeDescription]={'ASN'}>}Sum([ReceiptH.Records])

KPI#2 = sum({<[ReceiptH.StatusCode]={'90'},[DocH.IsCancelled]={'No'},[DocH.AccountTypeDescription]={'ASN'}>}if([DocH.ActualPrintedDate]=[ReceiptH.InputDate],[ReceiptH.Records],0))/{<[ReceiptH.StatusCode]={'90'},[DocH.IsCancelled]={'No'},[DocH.AccountTypeDescription]={'ASN'}>}Sum([ReceiptH.Records])

Any idea? why rhe same concept dosn't apply to KPI#3?

Thanks in advance

[Or]

If you would like to use a calculation in master dimension or as a dimension in objects/filters, the best approach is to create it in the Data Load Editor or Data Manager, depending on where you loaded your data in the first place.

[mzim]

Thank you for your prompt response. However, I regret to inform you that I am unable to intervene as the product is pre-made and I am solely using it for data visualization and analysis purposes.