topic Re: Arnold in QlikView

Arnold

Sun, 20 Apr 2014 12:40:39 GMT

I Have One Table having 4 fields like Plant, prod_hier, date, Amount see the below table

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000
3211	2	02-04-2014	2000
3221	3	03-04-2014	3000
3231	4	04-04-2014	4000
3241	5	05-04-2014	5000
3251	6	06-04-2014	6000
3261	7	07-04-2014	7000
3271	8	08-04-2014	8000
3281	9	09-04-2014	9000
3291	10	10-04-2014	10000
4201	1	01-04-2014	1000
4211	2	02-04-2014	2000
4221	3	03-04-2014	3000
4231	4	04-04-2014	4000
4241	5	05-04-2014	5000
4251	11	16-04-2014	6000
4261	12	17-04-2014	7000
4271	13	18-04-2014	8000
4281	14	19-04-2014	9000
4291	10	10-04-2014	10000

My Question is PROD_HIER contains 2 equal 1's i want to display in PROD_HIER field 2 equal 1's as well as Plant field

plant prod_hier

3201 1

4201 1

as well as what is Greater than and Less Than of Plant used by prod_hier

Re: Arnold

Joseph_Musekura — Sun, 20 Apr 2014 12:51:32 GMT

Hi,

I can’t see what you want to achieve. Do you want to keep only
2 values in the column/field Plant?

Can you please add how the final table result (needed table
result) looks like?

/joseph

Re: Arnold

its_anandrjs — Sun, 20 Apr 2014 12:51:49 GMT

Please explain more about the requirement with an example.

Re: Arnold

Sun, 20 Apr 2014 13:05:44 GMT

FROM THE GIVEN TABLE

PLANT PROD_HIER DATE AMOUNT

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000
3211	2	02-04-2014	2000
3221	3	03-04-2014	3000
3231	4	04-04-2014	4000
3241	5	05-04-2014	5000
3251	6	06-04-2014	6000
3261	7	07-04-2014	7000
3271	8	08-04-2014	8000
3281	9	09-04-2014	9000
3291	10	10-04-2014	10000
4201	1	01-04-2014	1000
4211	2	02-04-2014	2000
4221	3	03-04-2014	3000
4231	4	04-04-2014	4000
4241	5	05-04-2014	5000
4251	11	16-04-2014	6000
4261	12	17-04-2014	7000
4271	13	18-04-2014	8000
4281	14	19-04-2014	9000
4291	10	10-04-2014	10000

I WANT TO DISPLAY LIKE THIS

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000

4201	1	01-04-2014	1000

AND WHICH ONE IS 'GREATER THAN' OR 'LESS THAN' IN PLANT USING PROD_HIER

Re: Arnold

its_anandrjs — Sun, 20 Apr 2014 13:11:47 GMT

Still not clear in which condition the below data shown.

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000

4201	1	01-04-2014	1000

Thanks

Re: Arnold

Sun, 20 Apr 2014 13:20:21 GMT

condition is ''if i click 1 i wanna show highest value of PLANT field''

Re: Arnold

Sun, 20 Apr 2014 13:51:26 GMT

condition is ''if i click 1 i wanna show highest value of PLANT field'' and i wanna add new field is highest column based on PROD_HIER

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000

4201	1	01-04-2014	1000

Finally i wanna display below given table

Once again the condition is highest value of the PLANT field based on PROD_HIER

plant prod_hier date Amount higher new field

3201 1 01-04-2014 1000 4201

Thanks

Re: Arnold

Sun, 20 Apr 2014 13:53:48 GMT

condition is ''if i click 1 i wanna show highest value of PLANT field'' based on PROD_HIER and i wanna add new field is highest column i.e 4201

PLANT	PROD_HIER	DATE	Amount
3201	1	01-04-2014	1000

4201	1	01-04-2014	1000

Finally i wanna display below given table

Once again the condition is highest value of the PLANT field based on PROD_HIER

plant prod_hier date Amount higher new field

3201 1 01-04-2014 1000 4201

Thanks

Arnold