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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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