Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

help needed with expression or any idea in the script

in the attached screen the for a given code and year.. i will get some percentage . And there is another table which will have percentage ranges.. based on the range values star values are given for each Code. In the attached example for code AAP2 and year 2014.. the Rate % is 47% (0.47) and in the range table it is given that for the code AAP2 there will be begin percentage and end percentage based on the range it should assign star 1. please advise how to write the expression. Thanks for your help.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

(Aggr(If((rate%)>=PtileBeg and (rate%)<=PtileEnd,Star),Star,MEASURE_ID) )

View solution in original post

7 Replies
Anonymous
Not applicable
Author

can anyone help me.. @massimo Gross

maxgro
MVP
MVP

maybe with extended interval match in the script

Anonymous
Not applicable
Author

i dont have timestamp or date columns . Do you think .. it will still work.

Anonymous
Not applicable
Author

If possible is there any syntax you can help me with

Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

Can you please help me with this . if there is a chance.

Anonymous
Not applicable
Author

(Aggr(If((rate%)>=PtileBeg and (rate%)<=PtileEnd,Star),Star,MEASURE_ID) )