Hi Community,
I have a data set which has information on invoices and all its charges.
The invoices usually get some kind of adjustments over a period of time. One invoice can have one or more adjustments.
Identifying invoices which have solar has been easy, but..
I am currently trying to create a table where an invoice has received an adjustment (one or more) but none of them are '*Solar*'. This has been easy to represent as a KPI but I having issues creating the same as a table.
The KPI that I have created is as follows:
Count(distinct InvoiceNo) - count(distinct {$-1<CT_Description={'Adjustment'}, IC_Description -= {"*Solar*"}>}InvoiceNo)
I have tried the following (for the table) which have given me no luck:
1. aggr(distinct {$-1<IC_Description -= {"*Solar*"}>},InvoiceNo)
2. =If(CT_Description = 'Adjustment' and Count(IC_Description = 'Solar')=0,MI_InvoiceNo)
The second one does not give me any error in the script section, but after applying it says 'Invalid dimension'.
Qlik Sense Business
Your help would be appreciated.
Kind regards
