Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
george54
Creator III
Creator III

Replace Dimension

Hi all,

I have created a new dimension ("DimensionZ") in the load script with different data than the normal Dimension. 

How can I use this Dimension in an object (e.g. KPI)? all other object are using the normal Dimension and should not be affected.

Normal case:
Count(Distinct {<[XIM_CAL.Calldirection]={'Inbound'}>} [%CallId])

Thank you.

Labels (1)
3 Replies
Qlik1_User1
Creator III
Creator III

Please provide more details..

george54
Creator III
Creator III
Author

DimensionNormal is the normal Case. DimensionZ should only be use in one specific diagramm-object.

Load
[XIM_EVE.RecT] as DimensionNormal
If(IsNull([XIM_EVE.RecT]), [XIM_EVE.T2], [XIM_EVE.RecT] as DimensionZ
FROM [.....qvd] (qvd)

george54
Creator III
Creator III
Author

nobody has an idea?