Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TheBigC
Contributor II
Contributor II

Set Expression based on one filter value only

Why my formula below not working.

I have two KPI

  1.  count total selected customers based on all the selections.(This one is working)
  2. Count total customers for one week which dynamic. (should change only for different week) this one is not working
    • COUNT{<[ Week] = {GetFieldSelections([Week])}>} [Account No])

 

Labels (1)
1 Solution

Accepted Solutions
TheBigC
Contributor II
Contributor II
Author

Thanks Taoufiq for quick response. Formula that you suggested did not work,but helped me a lot to get to the right solution.

Formula that worked : =COUNT({1<[Week] = {"$(=GetFieldSelections(Week))"} >} [Account No])

View solution in original post

2 Replies
Taoufiq_Zarra

@TheBigC 

May be :

=count{<[Week]={"$(=GetFieldSelections(Week))"}>} [Account No])
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
TheBigC
Contributor II
Contributor II
Author

Thanks Taoufiq for quick response. Formula that you suggested did not work,but helped me a lot to get to the right solution.

Formula that worked : =COUNT({1<[Week] = {"$(=GetFieldSelections(Week))"} >} [Account No])