Hi all.

I have three tables which are linked through a common id (Management.id).

These are:

- Management table

- Details table; and

- Evidence table

When an item is deleted from the Management table in our front end we set a parameter [is deleted] to 1 and this is stored in the Management table (but none of the others).

When I join the tables through the Management.id I am loading up all of the data, but I only want to load up the records which have not been deleted.

- below is a cut down extract of the load script.

[tech_organizational_controls_management]:
LOAD
	[id] AS [Management.Management_id],
	[SOA_Version],
        [is_Deleted],
	[created_at],
	[updated_at],
	[standard_id];
SELECT id,
	`SOA_Version`,
	`is_Deleted`,
	`created_at`,
	`updated_at`,
	`standard_id`
FROM `xxxxxxx`.`tech_organizational_controls_management`;



[tech_organizational_control_details]:
LOAD
	[id] AS [control_details.id],
	[control_owner] as [Control Owner],
	[reason_control] as [Rationale],
	[control_implement] as [Implemented],
	[version_id] as [Details.Management.id],
	[object_id],
SELECT id,
	`control_owner`,
	`reason_control`,
	`control_implement`,
	`version_id`,
	`object_id`,

FROM `xxxxxxxxx`.`tech_organizational_control_details`;

[tech_organizational_controls_evidence]:
LOAD
	[id] AS [evidence.id],
	[evidence_type_value] as [Evidence Type],
	[evidence_type] AS [Evidence Category],
	[version_id] AS [Evidence.Management.id],

SELECT id,
	`evidence_type_value`,
	`evidence_type`,
	`version_id`,
FROM `xxxxxxxx`.`tech_organizational_controls_evidence`;

What is my best approach?

Thanks

Mark

stuck on this ...at a bar chart, want to show inactive customers with no sales during the past three month.

let's say I have time range as "Saledate = {">=$(=addmonths(Monthstart((vSaleMaxDate)),-3))<=$(=addmonths(Monthend((vSaleMaxDate)),-1))"}"

How do I add this into below so that I could have the set expression to have those customers who do not have any sales during the saledate period? 

sum({<[Customer Name]={"=sum([Sales]) = 0"}>} [Sales])

or maybe there is a better alternative without using any of these...

I'm facing a problem with a combo chart.
I want to show the maximum and the minimum value of a measure (only two highlighters), but minimum highlighter appears repeatedly in every month and far from the line.

Can someone help me, please?

MEASURE (line): count(distinct Chave_Contrato)

HIGHLIGHTERS
Max: =if(count(distinct Chave_Contrato)=max(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Min: =if(count(distinct Chave_Contrato)=min(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)

Thanks!

Hello, 

Is it possible to add section access to a data gateway so that when I access the tables in SQL Server the connector is pulling from, i can see all data, but another user with a professional license would only have access to certain data?  

Hello,

 I'm working on creating a report in Excel using NPrinting. I have a table with up and down arrows showing the increase/decrease in values based on 2 years. When trying to add the table in NPrinting Designer, unable to import the table with borders and alignment from the source. If I uncheck the 'Source Format' option, I'm able to import the table but lose the color codes for the up/down arrows. I tried using conditional formatting in Excel but the expression in Qlik Sense is too large to use in Excel. Is there any workaround for this issue? Please help.