How to combine 2 values for new value in table?

[satyam285889]

I have this table below that shows unit per finance type. I was keep show these value, but add new finance type that adds up 'Finance' + 'Cash' together and show as 'Non-Lease'. 

Also 'Finance' + 'Lease' as 'Non-Cash'

EX:

[PrashantSangle]

where do you want to do this logic to get implemented. in front end or in script ( back end)

In backend try like

Finance_table:

Load Deal,units from TableName;

concatenate

Load 'Non-Cash' as Deal,Sum(units) as units from TableName where wildmatch(Deal,'Finance','Cash');

concatenate

Load 'Non-Lease' as Deal,Sum(units) as units from TableName where wildmatch(Deal,''Finance,'Lease');

in front end you have to use valuelist() for this

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Sy...

Regards,

Prashant Sangle

[satyam285889]

Front-end. I have a table.