Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Cumulative count in bar chart with two dimension

Hello ,

I have to cumulate count in a bar chart object , 

test.PNG

I used this set analysis it works but there is two wrong values dates :

Aggr(RangeSum(Above(Total Count(distinct{$<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo())), Envirement, (Migration_date,NUMERIC, ASCENDING))

2.PNG

Any ideas please ? 

 

Thank you 

 

@sunny_talwar 

1 Reply
PradeepK
Creator II
Creator II

Avoid doing it in expression.. Look into : The-As-Of-Table 

Also as per shared screenshot it seems like issue with "2021-10" and "2021-11" is due to missing DEV, STD dimension data.

Please share some sample data to debug it further.