Formula to table?

alexis — Tue, 06 Oct 2015 21:16:35 GMT

The below represents the formula that I use to calculate a KPI.

As you can see the formula consists of a number of elements that refer to a number of dimensions (like "Software Owner", "ModelID") as well as "filters" such as "Vendor Name", TFDescription" etc.

I get the correct result (the number of Terminal_ID that meet the criteria that I specify) but now I need to create a table of the "qualifying" terminals and their dimensions - any idea how I can use this formula to create the results table?

Your help would be highly appreciated

= count (

{$<

[$(=Concat({1<$Field-={'VendorName','ModelName','TFDescription','SerialNumber','TID','MerchantID'}>}distinct $Field,']=,[')&']='),

[Terminal_ID] = E({1<[stat_type] = {'1','2','3'}>}),

[SoftwareOwner] = {'999'},

[ModelID]= -{'25','26','27'},

[ProdOUTNumeric] = {'>=$(=Min(DateNo))'},

[ProdINNumeric] = {'<=$(=Max(DateNo))'}

>} DISTINCT [Terminal_ID])

Re: Formula to table?

Clever_Anjos — Tue, 06 Oct 2015 21:18:58 GMT

create a graph simple table
Add Terminal_ID as dimension
Add other dimensions
Add that formula as first expression
Hide the last column if you want (Presentation Tab)

Re: Formula to table?

alexis — Tue, 06 Oct 2015 21:35:31 GMT

Excellent - your solution is exactly what I was after.

Thank you Clever Anjos!

topic Re: Formula to table? in QlikView

Formula to table?

Re: Formula to table?

Re: Formula to table?