Guide for migrating from PowerBI til QlikSense?

[OysteinT]

Hi all,

new here 🙂 

Are there any good blogs, books or other things which can be good guides on how to understand how to migrate some functions from DAX (PowerBI/Pivot) to QlikSense?

It is espesially how to do the same thing as the RELATED[] function in DAX I want to do, as I have a calculated field with several IF conditions which do a couple of different RELATED[] checks. (It is attached if anyone wants to see how it looks in Powerpivot..)

I have loaded all my data in QS, created associated on the correct table fields but I need a good guide on how to use the associations in function conditions like IFs. 

With regards, 
Øystein

[Wlad_Masi]

In QlikSense If statements are like "If(condition, true, false)"
Ex:
If(Name = 'John', 1,0)
This expression would show me 1 for names = John and 0 to other names.

Variables are used like =$(variable), what means that you are looking for the result of the variable.

I hope this helps you a little bit.