Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
))
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:
Maybe I think that I don't understand your problem.
No error while creating. But when selecting that in a table or chart, it's showing as invalid dimension.