Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-02-20 06:42 AM

Aging

Requires aging of item,supplier,customer.

in MDM module.

item : 0 to 2 days,3 days,4 days and more than 4 days

supplier : 0 to 1 days,2 days,3 days and more than 3 days

customer : same as supplier

Please send the qvw as soon as possible.

Regards,

351 Views
0 Likes
3 Replies
Not applicable
‎2013-02-21 03:13 AM
Author

can anybody help me on this query.

212 Views
0 Likes
vikasmahajan
MVP
MVP
‎2014-01-06 05:39 AM

Have you got solution for the same ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
212 Views
0 Likes
Not applicable
‎2014-01-06 05:46 AM
Author

Hi,

You can load something like this

IF(AGE >1 AND AGE<= 20, DUAL('1-20',1),

    IF(AGE>=21 AND AGE<= 25, DUAL('21-25',2),

    IF(AGE>=26 AND AGE<= 30, DUAL('26-30',3),

    IF(AGE>=31 AND AGE<= 35, DUAL('31-35',4),

    IF(AGE>=36 AND AGE<= 40, DUAL('36-40',5),

    IF(AGE>=41 AND AGE<= 45, DUAL('41-45',6),

    IF(AGE>=46 AND AGE<= 50, DUAL('46-50',7),

    IF(AGE>=51 AND AGE<= 55, DUAL('51-55',8),

    IF(AGE>=56 AND AGE<= 60, DUAL('56-60',9),    

    IF(AGE>60, DUAL('60+',10))))))))))) AS [Age Band]

in your load script. AGE is your Column name.

Thanks,

Selvakumar


     

212 Views
0 Likes