topic Re: Combining fields into one field in QlikView

Combining fields into one field

khaycock — Sat, 16 Nov 2024 03:53:12 GMT

I have the following bit of my script that I was hoping to be able to combine into one big field rather than split it up into 7 different ones.

Can I make the results of these combine into one field that is called ControlReporting and it spits out the same 'Not Reporting' and 'Is Reporting' results?

if(date(today())-15 >= ControlSCCM, 'Not Reporting', 'Is Reporting') AS SCCMReporting,
if(date(today())-15 >= ControlEpo, 'Not Reporting', 'Is Reporting') AS EPOReporting,
if(date(today())-15 >= ControlQRadar, 'Not Reporting', 'Is Reporting') AS QRadarReporting,
if(date(today())-15 >= ControlTenable, 'Not Reporting', 'Is Reporting') AS TenableReporting,
if(date(today())-15 >= ControlCredant, 'Not Reporting', 'Is Reporting') AS CredantReporting,
if(date(today())-15 >= ControlERPM, 'Not Reporting', 'Is Reporting') AS ERPMReporting,
if(date(today())-15 >= ControlCyberark, 'Not Reporting', 'Is Reporting') AS CyberarkReporting

Re: Combining fields into one field

vvira1316 — Thu, 11 Apr 2019 13:37:41 GMT

Hi,

I'm not sure if you were expecting as following

if(date(today())-15 >= ControlSCCM, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlEpo, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlQRadar, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlTenable, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlCredant, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlERPM, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlCyberark, 'Not Reporting', 'Is Reporting') AS ControlReporting,

Above is not correct as you can't have same field names.

So not sure why you are expecting it to be one field. It will be helpful if you will share sample data, script and explain your requirements in more detail.