Hi,

Below statement is giving an error

IF([Cost  excl. Tax]<=0,'Excluded','Check'='Excluded' or      if([Damage Tag]<>1 and ([Cost  excl. Tax]/Quantity<=1000),'Excluded','check')='Excluded' or      if( ApplyMap('Claim_Type',"Claim type [PAR]",'check')='EXCLUDED' or      if([Damage Tag]<>1,ApplyMap('Part_Number',Material,'check'))='EXCLUDED'),'EXCLUDED PART','REQUIRED PART'  as  A,

I have 2 tables , Current and Last year.  I want to add one more field "status" to define

New  = if Trade ID exists only in [Current] table

Exist = if Trade ID exists in both tables

Matured = If Trade ID exists in [Last Year] table and Matdate > Report date

I only know how to create in Excel formula but do not know how to create in Qlik sense. 

Would like to seek expertise on it.

I have to intercept (and calculate) the change of drugs distributed (AP_MINSAN10) between two delivery dates (FA_DATA_EROG) per patient (c.d. SWITCHED PATIENTS)

In the example attached the 

PROVA PAZIENTE1 have n.2 switch

PROVA PAZIENTE2 have n.3 switch

PROVA PAZIENTE3 have n.1 switch

Can you give me the correct expression for count these occurences?

Hi guys,

I am new to Qlik Sense and have to create a dashboard using data on helping the environment.

I would like to have a theme colour of green across all graphs in sheet(s).

I see no option to choose a theme colour. Does anyone know a quick way how I can use a theme colour for background and content of charts etc.?

Hello Guys,

I am trying to install QDC on CENT OS 8 on VM following QDC Installation guide by QlIK.

But after installing PostgresSQL,  I am getting error as shown in the attachment

qdc_pg-11.2 service failed to run

I tried several times but getting same error.

Please help me on this.

Thanks!

Buenos días,

Estoy empezando a manejar Qlik Sense y quería saber si me podéis solucionar el siguiente problema.

Introduzco una fórmula de if donde el cliente me solicita bastantes condiciones y llego a un punto que no me deja introducir más porque me indica: if takes 2-3 parameters.

He introducido tres condiciones con dos if cada una pero cuando voy a meter otra, me da el problema reseñado.

Un saludo.

Dear Experts,

Need experts help for below requirement.

There are two straight table. Inherited and MyState. Both the table should show results on some common filters. Lets say any Year is selected, then this selection should be applied in both the table for selected value in Year field. And data in MyState table  should contain only data present in Inherited State after the selection done in Year field. And how can i show the difference of these two total value's with different state in KPI.

Would great for asap response.

Regards,

Nitin. 

Hi All

Recently Qlik start to implement business cloud subscription USD 30 Per month. I like to know that are developer able to implement section access to protect certain user to access data. His section access is implement in Qlik view ver 9.

Paul

My pivot table shown below has two dimensions, with the first being the ProcedureSurgeonName.

I have the following expression calculating my ranked dimension, which is the second dimension.

aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)

My expressions are the following:

Supply Total Cost:  SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)

and 

Percent of Total:   SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)/SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL SupplyChainLUOMTotalCost)

As you can see in the table above my percentage of total is displaying across all Physician's so i've changed it to aggr on the Vendor Name, using the following.

SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)/SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL <VendorName>SupplyChainLUOMTotalCost)

But, my totals still aren't displaying properly, it should be 100% for each Physician total and then each vendor will add up to the 100%.  I'm using the calculated dimension above for the vendor, but this is how my totals display when aggr by vendor.  

I've also tried the following which yields no results:

SUM({<VendorName = {"=aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)"},ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)

/

SUM({<VendorName = {"=aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)"},ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL <VendorName>SupplyChainLUOMTotalCost)

How can I get the % of Total column to display the percentages by my calculated dimension?