Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Combining fields into one field

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

Labels (1)
1 Reply
vvira1316
Specialist II
Specialist II

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.