Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chitemerere
Specialist
Specialist

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.

chitemerere
Specialist
Specialist
Author

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

chitemerere
Specialist
Specialist
Author

Thank you very much i will try it out

chitemerere
Specialist
Specialist
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?