Forum Discussion
Helper IVDimensionality (QlikView) in PowerBI
Hi guys,
I've to convert a QlikView report in a PBI report.
In a table there is a measure like "if ( dimensionality = 0, A, B).
I think I understand the meaning but I don't know which function can I use.
Can you help me?
Thank you 🙂
I've solved the problem of DIMENSIONALITY (QlikView) using the function ISINSCOPE that allows me to manipulate the dimension of the matrix
5 Replies
- Greg_Deckler
Community Champion
giuliapiazza94 What is dinensionality? If it is a measure or column you could do IF([dimensionality]=0,"A","B")
giuliapiazza94A column.
For example
dimensionality (A and B and C) = 2
dimensionality (D) = 1
the 3 rows has dimensionality = 0
It should be correct
I can't use IF (column) but I can only do IF (measure)
Hello,
you can use if in Power BI in measure or column.
But what I think here is happening that the dimensionality is Qlik Variable and in this case condition is that if dimensionality= False.
v-yanjiang-msftCommunity Support
Hi giuliapiazza94 ,
According to your description, you can use MAX function, it will return the value of current row. You can use it like this:
Or you are still confused about it, please provide me with more details about your issue.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- giuliapiazza94
I've solved the problem of DIMENSIONALITY (QlikView) using the function ISINSCOPE that allows me to manipulate the dimension of the matrix
