topic Re: Dual(SubField(Class())) in QlikView

Dual(SubField(Class()))

tracycrown — Sun, 27 Dec 2020 16:34:56 GMT

Dear all

Merry Christmas and Happy New Year to all of you.

I need help urgently on how to equal interval in Sales $'M with decimal point using Dual(SubField(Class())) function.

The answer I would like to see is as follows :

Year	Sales $'M	No. of Company	Min	Avg	Max
2012	0 - 0.9	1	$167,823	$167,823	$167,823
2012	1.0 - 9.9	4	$1,186,050	$2,901,818	$3,706,467

Thank you so much, Tracy

Re: Dual(SubField(Class()))

Anil_Babu_Samineni — Sun, 27 Dec 2020 17:06:37 GMT

Why you are choosing Subfield(), Subfield never recommend in tabular until unless you have strong needs. Cant you add like

=If([Sales $'M]>=0 and [Sales $'M]<=0.9, '0-0.9', If([Sales $'M]>0.9 and [Sales $'M]>9.9, '1.0-9.9'))

Re: Dual(SubField(Class()))

tracycrown — Mon, 28 Dec 2020 02:17:42 GMT

Dear Mr Anil_Babu_Samineni

Thank you for your help.

Please advise what if I would like QV to auto generate the grouping with equal interval as follows :

0 - 0.9

1 - 1.9

2 - 2.9

3 - 3.9

Thank you, Tracy

Re: Dual(SubField(Class()))

Anil_Babu_Samineni — Mon, 28 Dec 2020 10:10:49 GMT

This will work normally

Class([Sales $'M], 0.9)

Re: Dual(SubField(Class()))

tracycrown — Mon, 28 Dec 2020 13:59:30 GMT

Dear Mr Anil_Babu_Samineni

Can you advise where to insert Class([Sales $'M],0.9) in the script or dimension?. Also, can you help to insert it in the attached Test-1.qvw?.

Thank you, Tracy

Re: Dual(SubField(Class()))

Anil_Babu_Samineni — Mon, 28 Dec 2020 15:40:56 GMT

Do you have data with respect to point decimals? If so data will come, As i can see If i add the same as dimension the data is coming weird. Don't know what you are referring here for these

0 - 0.9

1 - 1.9

2 - 2.9

3 - 3.9

Re: Dual(SubField(Class()))

tracycrown — Mon, 28 Dec 2020 16:46:47 GMT

Dear Mr Anil_Babu_Samineni

Can you advise how to group Sales $'M automatically in the above format 0-0.9, 1-1.9 etc ?. Please note that It is perfectly OKay if some grouping (2-2.9) does not have data for Year 2012. :

0-0.9 1 - Company B

1-1.9 1 - Company A

2-2.9 0 - None

3-3.9 3 - Company C, D & E

Thank You, Tracy