Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
I have 2 data sets which I want to combine into the one table.
I also only have a diluted version of Qlik sense so would need to be able to create this using an expression in the 'edit expression' section.
Many thanks to all those who take the time to read and help.
Louise
With [Database Registration] as your dimension, you could use the following as a measure:
=Concat(if([Database Registration]=[Checklist Registration],[Checklist Registration],''))
Thanks for responding. Have tried that but still doesn't pull any values through. so the Checklist Registration column is blank 😞
@GaryGiles answer should work -- if you use [Database Registration] as Dimension in the chart and his expression as Measure. Do you have a dimension?
-Rob
Unfortunately it literally doesn't pull anything through at all 😞
So, in your actual data, the Database registration field is named [Risk Assessments: Additional control measures]
and Checklist Registration is named [Audits: Vehicle registration]? Are the tables in your data model joined by any field? What does the data model look like?
Yeah the data is actually stores in the risk assessment module and the checklists completed in our audits & inspections module. Would I need our supplier developers to link the two fields together somehow in order to be able to successfully compare the 2? Both datasets are free text boxes with validation rules on to prevent spaces or special characters being used.
No, the tables don't need to be joined. I was asking to see if there might be something else causing the expression to not return values. Attached is a qvf with the tables loaded via an inline script and the expression returning the appropriate values.
I can't open the attached file. We only have a diluted version of Qlik as embedded into one of our supplier systems so we can't do anything other than write scrip using the expression editor functionality.