Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculated Dimension

I have the following straight table:

GenericDrugEntryPatentSelection.JPG

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

6 Replies
nevilledhamsiri
Specialist
Specialist

Hi Chris,

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

Neville

vishsaggi
Champion III
Champion III

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
Not applicable
Author

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

Anonymous
Not applicable
Author

Thank you very much i will try it out

Anonymous
Not applicable
Author

Dear Vishwarath

Thank you very much but it is not working

vishsaggi
Champion III
Champion III

‌ccan you share a sample file to look into?