Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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