Re: Need to show a chart with count of items with ... - Qlik Community

Harish_Qlik_user · ‎2020-10-06

Hi,

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

Code

Country

Date

Vendor

so below is how it should show count at each country , sum amount >1 million with aggregation at code, date, vendor for each country.

avinashelite · ‎2020-10-06

Try like this

Dimension: Country

Expression = count({<Amount={">1000000"}>}Amount)

Harish_Qlik_user · ‎2020-10-06

thanks for reply but this will just filter the data for amount greater than million but I need sum(amount)>1m grouped at code,Posting date,vendor,

Usama · ‎2020-10-06

Hi,

try this:
Count({<Amount={">1000000"}>}Code)
this will give you count across all fields you mentioned

Thanks

From Nothing - To Something - To Everything

Kushal_Chawda · ‎2020-10-06

@Harish_Qlik_user How it is 2 for GB?

Harish_Qlik_user · ‎2020-10-06

@Kushal_Chawda I just have random numbers. I was trying to show how the final output should be.

Kushal_Chawda · ‎2020-10-06

@Harish_Qlik_user Then what @avinashelite suggested should work. If not share the expected output for the above data

Harish_Qlik_user · ‎2020-10-06

@Kushal_Chawda @avinashelite please find the sample file.

Kushal_Chawda · ‎2020-10-06

avinashelite · ‎2020-10-06

@Harish_Qlik_user as per the excel output above mentioned expression will give you the desired results , not sure what your exactly looking for ?

Need to show a chart with count of items with amount greater than at each country