Calculated Dimension

[Anonymous]

I have the following straight table:

I need to have a calculated dimension 'Relevant Patent Number' based on the fields 'Patent Number' and 'DrugSubstanceFlag'.  The 'Relevant Patent Number' calculated dimension will be that Patent Number where DrugSubstanceFlag = 'Y'.  How can i accomplish this in QlikView.

Regards.

Chris

[nevilledhamsiri]

Hi Chris,

Why not do this in the script?. Please see whether this will suit your requirement

Neville

[vishsaggi]

For patent number dimension create a calculated dim like

= Aggr(If(DrugSubstanceFlag = 'Y',  [Patent Number]), [Patent Number])

then for this Dim check Supress When value is Null.

Missed a comma after 'Y'. Updated.

[Anonymous]

Thank you.  This is log file, how do i use it?

[Anonymous]

Thank you very much i will try it out

[Anonymous]

Dear Vishwarath

Thank you very much but it is not working

[vishsaggi]

‌ccan you share a sample file to look into?