Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Measure to dimension

Hi

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?

2 Replies
sasiparupudi1
Master III
Master III

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

qliksus
Specialist II
Specialist II

May be something like the below

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