topic Re: How to combine 2 values for new value in table? in App Development

How to combine 2 values for new value in table?

satyam285889 — Sat, 14 May 2022 05:16:19 GMT

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:

Re: How to combine 2 values for new value in table?

PrashantSangle — Sat, 14 May 2022 05:54:43 GMT

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/SyntheticDimensionFunctions/valuelist.htm

Regards,

Prashant Sangle

Re: How to combine 2 values for new value in table?

satyam285889 — Sat, 14 May 2022 20:17:42 GMT

Front-end. I have a table.