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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.