Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cnavarrete1
Contributor
Contributor

Create a new measure mixing other two that are working

I have two measures in Qlik Sense that are working:

A) Number of vendors with yearly invoicing < 18.000€ =

Count(distinct If(Aggr({<Transaction = {'Invoice'}>} Sum(Price), Year, VendorName)<18000, VendorName))

B) Number of vendors with invoices in every quarter =

if (Max([Month#])>9,

Count( {<VendorName = P({< Transaction = {'Invoce'}, Quarter={'Q1'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q2'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q3'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q4'}>})

>} distinct VendorName),

if (Max([Month#])>6,

Count( {<VendorName = P({< Transaction = {'Invoce'}, Quarter={'Q1'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q2'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q3'}>})

>} distinct VendorName),

if (Max([Month#])>3,

Count( {<VendorName = P({< Transaction = {'Invoce'}, Quarter={'Q1'}>})

*P({< Transaction = {'Invoce'}, Quarter={'Q2'}>})

>} distinct VendorName),

Count( {<VendorName = P({< Transaction = {'Invoce'}, Quarter={'Q1'}>})

>} distinct VendorName)

)))

Now, I want to create a new measure that combines both. That is to say: Number of vendors with yearly invoicing < 18.000€ that have invoices in every quarter.

¿Can you help me, please?

Mensaje editado por: Carlos Navarrete Sierra Measures modified because a translation problem

0 Replies