Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)