If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm looking for showing count of records which are more than 1 million for each country when aggregating at Code,Country,Vendor,posting date.
Below is the sample date and my actual data has more columns than below.
I need to show a graph with count of records at country level group by below columns and sum of amount > 1million
so below is how it should show count at each country , sum amount >1 million with aggregation at code, date, vendor for each country.
Use the sheet 1("Raw Data") and get the sheet2("Final Ouput")
There are few records which have same V_Code/date/ code for which I need to sum them and check if that sum is >1million and find count.
With your excel and same formal we are getting your excepted results