In my data base there are many products under 'CLA_CODE', within this cla_codes there a many sub products and Those are named as 'PRD_CODE'
Ex:- CLA_CODE PRD_CODE
PP SE
PP SA
PP DD
PP LI
MC 1A
MC 1B
MC 1C Like that,
in 'DD','SE','SA' and 'LI' Prd_code there are different premiums(prices) which are entitled different Commission amounts to the respective marketing force.
Then i have build three arguments in my basic formula,
1st and 2nd arguments are in order(expected output coming)
3rd one is 'RANGE1<PREMIUM<RANGE2'. Even though expression got 'OK',
This is not working as per my testing. Dear friends, please help me to find the mistake i have done or propose an alternative way to do this.
earlier there was a field "AG_RS",i think u changed that field name..no it's not appearing in ur application,just replace ur new field name with AG_RS,then values will reflect.
else u have the different formula,then u can place that.
note: we shared answers on ur earlier posts,seems those not marked...,if ur happy with those answers u can mark as correct.
You have requested urgent help, but your example file does not match your latest details. In order to get quick and accurate assistance you need to provide a proper description of you problem, this includes describing the result you get and the result you are expecting.
From your example file and additional comment I can see that you are not familiar with QlikView as a tool and the expression syntax in particular. For examples if you open the expression editor and there is a red line highlighting any part in the expression, it indicates an incorrect syntax or reference in the expression. As aninitial action I would recommend that you look in the help or reference manual for details on who the function should be defined. If you do not understand how a specific function work, please clarify in your question where you are stuck.
As a beginner it is wise to attend the free online training, so that you get familiar with how QlikView functions as a product. This is essential for your success as a developer. To deepen your knowledge the free training can be followed by virtual or real classroom training.
