Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravsinghtomar
Contributor II
Contributor II

How to create Variable in Qlik Sense like PowerBI DAX queries?

Hello,

How to create a variable in Qlik Sense report like this Dax queries(PowerBI) given below?

VAR Level_Check 
CALCULATE(
COUNTROWS(
FILTER(DFS_NTFS,NOT(DFS_NTFS[rootFolder]))),
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]))

VAR Accounts_countrows 
CALCULATE(
COUNTROWS(DFS_NTFS),
FILTER(
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]),
DFS_NTFS[Account.Check]<>"ADM_Built"))

VAR Admin_accounts
CALCULATE(
COUNTROWS(DFS_NTFS),
FILTER(
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]),
DFS_NTFS[Permissions.Check]="Admin Full Control"&&
DFS_NTFS[isInherited]))
Labels (2)
0 Replies