topic Re: class function Label in QlikView

class function Label

Anonymous — Wed, 28 Mar 2018 19:21:49 GMT

Hi Guru's,

I want to display Labels for my Combo chart are :<ok,0-10k,10-100k,100K-1M,1M+

how to achieve this using Class function

Please find the attached screen shot and Qvw

Thanks,

Raj

Re: class function Label

sunny_talwar — Wed, 28 Mar 2018 19:27:35 GMT

Try this instead of Class()

=Aggr(

If(Sum(Invoices) < 0, Dual('< 0', 1),

If(Sum(Invoices) < 10000, Dual('0-10k', 2),

If(Sum(Invoices) < 100000, Dual('10-100k', 3),

If(Sum(Invoices) < 1000000, Dual('100k-1M', 4), Dual('1M+', 5)))))

, [Invoice Number])

Re: class function Label

Chanty4u — Thu, 29 Mar 2018 06:17:59 GMT

check sample age bucket

Age Buckets.qvw

Re: class function Label

Anonymous — Thu, 29 Mar 2018 07:39:18 GMT

Hi Sunny ,

Thanks for your time.

in place of Sum (Invoices) i have expression as below

sum({<

[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}

>} [USD_Invoices.DISTRIBUTION_AMOUNT])

sum([EuticalsInvoices.Value Invoiced $])

sum([GadeaDP.FA Base USD])

How to use this in expression

Thanks,

raj

Re: class function Label

sunny_talwar — Thu, 29 Mar 2018 08:58:02 GMT

May be this

=Aggr(

If(

RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),

Sum([EuticalsInvoices.Value Invoiced $]),

Sum([GadeaDP.FA Base USD])) < 0, Dual('< 0', 1),

If(

RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),

Sum([EuticalsInvoices.Value Invoiced $]),

Sum([GadeaDP.FA Base USD])) < 10000, Dual('0-10k', 2),

If(

RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),

Sum([EuticalsInvoices.Value Invoiced $]),

Sum([GadeaDP.FA Base USD])) < 100000, Dual('10-100k', 3),

If(

RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),

Sum([EuticalsInvoices.Value Invoiced $]),

Sum([GadeaDP.FA Base USD])) < 1000000, Dual('100k-1M', 4), Dual('1M+', 5)))))

, [Invoice Number])