Solved: Arnold - Qlik Community

Report Inappropriate Content · ‎2014-04-20

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

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

its_anandrjs · ‎2014-04-20

Please explain more about the requirement with an example.

Joseph_Musekura · ‎2014-04-20

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

its_anandrjs · ‎2014-04-20

Please explain more about the requirement with an example.

Report Inappropriate Content · ‎2014-04-20

FROM THE GIVEN TABLE

PLANT PROD_HIER DATE AMOUNT

I WANT TO DISPLAY LIKE THIS

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

its_anandrjs · ‎2014-04-20

Still not clear in which condition the below data shown.

Thanks

Report Inappropriate Content · ‎2014-04-20

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

Report Inappropriate Content · ‎2014-04-20

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

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

Report Inappropriate Content · ‎2014-04-20

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

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