topic Re: if statement in expression using a calculated dimension in QlikView

if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 13:52:47 GMT

I have this dimension calculation which just groups two specialties together:

=if(CurrentSpec='ENDOC' or CurrentSpec='DIAB','DIAB/ENDOC',CurrentSpec)

then in an expression I need to allocate a number of beds to the specialty:

but it is not recognising my calculated dimension so i added the calucation back in but it still wont alocated a number to thtat combined specialty.

(i did have if(CurrentSpec='ENDOC' or 'DIAB','21', but this also didnt work)

if(if(CurrentSpec='ENDOC' or CurrentSpec='DIAB','DIAB/ENDOC',CurrentSpec)='DAIB/ENDCO','21',

if(CurrentSpec='CARD','18',
if(CurrentSpec='ELM','52',
if(CurrentSpec='GASTRO','28',
if(CurrentSpec='RESPMED','26',0)))))

is there a way of doing this other than maybe combining the speicalties in the script; but its always good to see them seperate in the raw data.

thanks for you help

Re: if statement in expression using a calculated dimension

sunny_talwar — Mon, 22 May 2017 13:55:34 GMT

May be like this

Dimension

=if(Match(CurrentSpec, 'ENDOC', 'DIAB'), 'DIAB/ENDOC',CurrentSpec)

Expression

if(Match(CurrentSpec, 'ENDOC', 'DIAB'), 21,

if(CurrentSpec='CARD', 18,
if(CurrentSpec='ELM', 52,
if(CurrentSpec='GASTRO', 28,
if(CurrentSpec='RESPMED', 26, 0)))))

Re: if statement in expression using a calculated dimension

sunny_talwar — Mon, 22 May 2017 13:56:39 GMT

Or this as your expression

Pick(Match(CurrentSpec, 'ENDOC', 'DIAB', 'CARD', 'ELM', 'GASTRO', 'RESPMED') + 1, 0, 21, 21, 18, 52, 28, 26)

Re: if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 14:10:45 GMT

thanks tried this and its still not populating for it.

i see you have posted again i will try that now

thank you

Re: if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 14:14:06 GMT

no just for that combined specialty it doesnt allocate it.

how bizarre

thanks for trying i have learned a new expression 'pick'

Re: if statement in expression using a calculated dimension

sunny_talwar — Mon, 22 May 2017 14:19:56 GMT

Would you be able to share a sample where this isn't working for you?

Re: if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 15:00:44 GMT

I have just scambled all the data, as its identifiable to patients. - i had to detele evertthing else in the app to make sure i could send the size over.

thanks

Re: if statement in expression using a calculated dimension

sunny_talwar — Mon, 22 May 2017 15:02:41 GMT

Do you have section access? I am unable to open the file

Re: if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 15:04:08 GMT

sorry i dont know what that means?

Re: if statement in expression using a calculated dimension

sunny_talwar — Mon, 22 May 2017 15:06:27 GMT

Its a type of security. You can read about it here:

Introduction to Section Access

Re: if statement in expression using a calculated dimension

qliklizzy — Mon, 22 May 2017 15:19:05 GMT

thanks, i will have a further read on this when i have some more time.

We had some external suppliers help with the set up of these apps - i dont think i want to mess around with security without properly reading up on it.

thanks for all your help,