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

How to apply dynamic count if based on value of the data

Dear all, 

I am trying to count the values based on condition. Below is the scenario. I have a table with group, date and score below 

GroupsDateScore
groceries05_20162
groceries06_20163
groceries07_20162
groceries08_20163
groceries09_20161
groceries10_20163
Electric05_20163
Electric06_20164
Electric07_20164
Electric08_20164
Electric09_20161
Electric10_20163
mail05_20164
mail06_20162
mail07_20163
mail08_20161
mail09_20163
mail10_20164
Telephone05_20165
Telephone06_20162
Telephone07_20162
Telephone08_20163
Telephone09_20164
Telephone10_20163
Rent05_20162
Rent06_20161
Rent07_20163
Rent08_20164
Rent09_20165
Rent10_20163
Wlan05_20161
Wlan06_20163
Wlan07_20161
Wlan08_20162
Wlan09_20163
Wlan10_20163

 

when I convert this table into pivot table the value look like this 

Groups05_201606_201607_201608_201609_201610_2016
groceries232313
Electric344413
mail423134
Telephone522343
Rent213453
Wlan131233

 

I would like to count all the possible combinations where I have the combination of  1  in first columns and 3 in the respective column and 2 in first columns and 3 in the next columns. for example : 06_2016 has 1 as rent and 07_2016 as 3 as rent. 

I would like to do for all the month dynamically i.e. everymonth when new month data is added it should automatically count the all the possible combination of (1 and 3 ) and (2 and 3) for all the month. Could some one please try to help me to resolve the above issue ? It will be a great help. 

 

Thanks and regards

Iras

0 Replies