Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
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
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:

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

Contributor III
Author

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