Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
flames
Contributor III
Contributor III

calculated dimension in Qlik Sense

Hi, This is related to qlik sense.

I am trying to create a dimension with shows buckets for a measure.

I am able to create a master measure with this formulae but not master dimension. can someone help on this

my measure :

 

SUM(
{
<src={"NA","FN"}, $(vSet1)>
+ <src={"NA","FN"}, WEEK={"CURWK"}, STAT={"PRD", "CLOSED/CY PRD"},QTR={">=$(vQTR)"}, FLAG={"Y"},NDO_FLAG={"Y"}>
}
((OSP - ALT(OSP_SC,0))/(OSP))
)

 

dimension i am trying to create :

 

If((SUM(
{
<src={"NA","FN"}, $(vSet1)>
+ <src={"NA","FN"}, WEEK={"CURWK"}, STAT={"PRD", "CLOSED/CY PRD"},QTR={">=$(vQTR)"}, FLAG={"Y"},NDO_FLAG={"Y"}>
}
((OSP - ALT(OSP_SC,0))/(OSP))
))<=0, '(0 & LESS]',
If((SUM(
{
<src={"NA","FN"}, $(vSet1)>
+ <src={"NA","FN"}, WEEK={"CURWK"}, STAT={"PRD", "CLOSED/CY PRD"},QTR={">=$(vQTR)"}, FLAG={"Y"},NDO_FLAG={"Y"}>
}
((OSP - ALT(OSP_SC,0))/(OSP))
))<=0.10, '(0 & 10]',
'>10'
))

2 Replies
Miyake_Diogo
Contributor
Contributor

Hi, 

 

When you try to create a Master Dimension appear an error message? 

Cause I attach our code in my Qlik and I get make a Master Dimension.

See my Image:

Image 7.png

 

Maybe I think that I don't understand your problem.

flames
Contributor III
Contributor III
Author

No error while creating. But when selecting that in a table or chart, it's showing as invalid dimension.