How to create new Variable based on another multiple Variable using if, else statement ??

[gauravsinghtomar]

Hi, I am looking for any advice on how to create variable and call in Qlik Sense report. 

Q. How to create a new variable using (filter, if, if else statement) on a different variable on the same calculated field? Please find the attached document of this power bi DAX Queries? Is the syntax similar in Qlik Sense or any option?

Power BI DAX Queries given below. I need syntax similar to these:-

Column1	Column2	Column3	Column4	Column5	Permission.Check
1	Permission	John		Allow	Permission
1	Permission	John		Allow	Permission
1	Delete	John		Allow	Permission
2	Permission	John		Allow	Delete
2	Permission	John		Allow	Delete
2	Delete	John		Allow	Delete
2	Delete	John		Allow	Delete
3	Permission	John		Allow
3	Delete	John		Allow
4	Permission	John	XYZ	Allow
4	Delete	John		Deny

Permissions.Check =

VAR Permissions = CALCULATE(COUNTROWS(TableName),ALLEXCEPT(TableName,TableName[column1],tableName[column2]))

VAR Delete =
    CALCULATE(
        COUNTROWS(TableName),
            FILTER(
                ALLEXCEPT(TableName,TableName[column1],TableName[column2]),
                    TableName[column3]="John"&&
                    ISBLANK(TableName[column4])
                )
            )

RETURN
SWITCH(TRUE(),
    TableName[column5]<>"Allow",BLANK(),

    Permissions=2&&Delete=1,"Permission",

    Permissions=2&&Delete=2,"Delete",

   BLANK()

)

[killersswang]

From my point of view Variables in Dax(Power BI)  and Variable in Qlik is  different.