Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

Row by Row Calculation in Bar Chart

Salutations Qliksters! 

 

What would be the best way to calculate "row-by-row" in a bar chart with an expression that uses set analysis?

 

For each day, I want to find, within a defined date range, how many days a KPI value was exceeded per day. 

Here is the desired output:

 

Within 1/12/2020 thru 1/14/2020, there were 2 days that had KPI value >=3

Sazabi_1-1607714140121.png

 

-------------

Within 1/11/2020 thru 1/13/2020, there was 1 day that had KPI value >=3

Sazabi_2-1607714157893.png

------------------

Within 1/10/2020 thru 1/12/2020, there were 2 days that had KPI value >=3

Sazabi_3-1607714176794.png

etc, etc....

 

Any ideas?

 

 

Thanks!!!

 

 

S

0 Replies