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
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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