topic Re: Calculated Dimension in QlikView

Calculated Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Calculated Dimension

nevilledhamsiri — Wed, 26 Sep 2018 17:35:55 GMT

Hi Chris,

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

Neville

Re: Calculated Dimension

vishsaggi — Wed, 26 Sep 2018 17:37:13 GMT

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.

Re: Calculated Dimension

Anonymous — Thu, 27 Sep 2018 16:16:09 GMT

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

Re: Calculated Dimension

Anonymous — Thu, 27 Sep 2018 16:16:34 GMT

Thank you very much i will try it out

Re: Calculated Dimension

Anonymous — Sat, 29 Sep 2018 07:50:53 GMT

Dear Vishwarath

Thank you very much but it is not working

Re: Calculated Dimension

vishsaggi — Sat, 29 Sep 2018 12:44:48 GMT

‌ccan you share a sample file to look into?