topic Measure to dimension in QlikView

Measure to dimension

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

is there a way to convert a calculated measure to a dimension?
I have an if statement formula that I would need to use in a set analysis but I am not able to do that

If I could convert it into a dimension then I would be able to use it in a set analysis

Here is my if statment

=if (sum(sumPatientSatisfactionSurvey )>0,1, sum(sumPatientSatisfactionSurvey )) +

if (sum( sumMeasuringTNA) > 0,1 ,sumMeasuringTNA ) +

if (sum(sumMeasuringScreening) > 0,1 ,sumMeasuringScreening ) +

if (sum(sumQIProject1Project) > 0,1 ,sumQIProject1Project)

What i would want to find out is

Count ({<(if (sum(sumPatientSatisfactionSurvey )>0,1, sum(sumPatientSatisfactionSurvey )) +

if (sum( sumMeasuringTNA) > 0,1 ,sumMeasuringTNA ) +

if (sum(sumMeasuringScreening) > 0,1 ,sumMeasuringScreening ) +

if (sum(sumQIProject1Project) > 0,1 ,sumQIProject1Project)) ={"1"}>} physicianID)

But I can't do that

Any suggestions?

Re: Measure to dimension

sasiparupudi1 — Thu, 03 May 2018 03:00:10 GMT

Not sure I understand your issue..Do you wish to convert a calculated dimension to a measure?

did you try using a simple measure like

Count(physicianID)?

pl podt a sample app

Re: Measure to dimension

qliksus — Thu, 03 May 2018 04:29:53 GMT

May be something like the below

Count({<physicianID={"=sum(sumPatientSatisfactionSurvey )>0 or sum( sumMeasuringTNA) > 0 or sum(sumMeasuringScreening) > 0 or sum(sumQIProject1Project) > 0 "} physicianID)