Discussion Board for collaboration related to QlikView App Development.
I want to write expression which needs to group my field value.
I have a column name called "Invstatus" under this we have 2 options Invoiced & Not Invoiced. Users enter like dis for invoiced
Invoiced, Invoiced, Invoiced
While I apply condition to show only invoiced amount it takes only field value Invoiced remaing invoiced, invoiced are left out. I need to group them all into single field like dis
How can I achieve this by using qlik expression?
If(Left(Invstatus,3) = 'Not', 'Not Invoiced','Invoiced') as NewInvstatus,
View solution in original post
it seems like a description field. Can the user put any value in this field?
There are several ways to group a field but you willl give us a rule to determinate when a row is invoiced.
ERP systems usually have a flag-field with this information.... Y/N. Check with your provider...
for example index function:
LOAD if(index(Upper(Invstatus), 'NOT')>0, 'Not Invoiced', 'Invoiced') as Invoiced?, * INLINE [
E.g.: Not Invoiced