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
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
apoorva11
Contributor II
Contributor II

Count of Max Activities Done

I have data like below table in which i am showing Region wise Total Visits done on a store by ABM. Now suppose i have 3 KPIs : Inventory Support , Price Drop Module, Demo Validation . It shows count of stores that have filled these modules respectively.

Query : I need to create a 3rd KPI : Total Activities which will show count of Modules/KPIs filled (Inventory Support, Price Drop Module, Demo Validation) . So max value will be 3 and min will be 0. Is there any function which can be used for this in chart instead of using nested if else. 

RegionTotal Visits DoneInventory SupportPrice Drop ModuleDemo ValidationTotal Activities Done
East1055001
West2003453
North3002302
South980000
1 Solution

Accepted Solutions
apoorva11
Contributor II
Contributor II
Author

I have got the solution of this : 

=Rangemin(Column 1, 1) + Rangemin(Column 2, 1) + Rangemin(Column 3, 1).

 

View solution in original post

1 Reply
apoorva11
Contributor II
Contributor II
Author

I have got the solution of this : 

=Rangemin(Column 1, 1) + Rangemin(Column 2, 1) + Rangemin(Column 3, 1).

 

View solution in original post