Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

HOW TO SUMMARIZE SERIAL CONTINUITY AS PER DIFFERENT BRANCH

Dear Friends

How to show 1st & last number something like below when expanded serial is presented?

Thanks

 

Neville

 

 

BRANCH       SERIEAL

RA                    112545-112554

EH                    112555-112563

8 Replies
sunny_talwar

Is this what you want?

image.png

nevilledhamsiri
Specialist
Specialist
Author

Yes

Could you please send me the expression/script which resulted in the expected output. I cannot open up the qvd

Thanks

 

nevilledhamsiri
Specialist
Specialist
Author

Please look in to this.

Thanks

Neville

nevilledhamsiri
Specialist
Specialist
Author

In the case two serials are continuing for THE same Branch, that too should reflect in the respective Branch. Eg As per Branch RA it has two serials. Once this is done the final results should be like below

 

RA                   112545-112554     10

RA                   115450-115455      6

EH                  112555-112563      9   

 

Please refer this data set & recommend me a easy solution. You may send me the formula that should be written to achieve this. QVW cannot be opened up.

Regards

 

Neville

 

Kushal_Chawda

@nevilledhamsiri  how do you identify  two serial for RA.. serials are same for both FROM and TO

nevilledhamsiri
Specialist
Specialist
Author

Since two serials are applicable for RA00, Can it be shown under two rows such as how I have shown. Because one serial goes from 112545-112554   & other serial from 115450-115455 . 

nevilledhamsiri
Specialist
Specialist
Author

If I cannot have two different serials for RA, the voucher allocation count for RA cannot be properly made. Because if we get the difference of 112545-115455, the answer is not correct. but it should be the difference of (112545-112554) & (115450-115455) separately to have the exacts voucher allocations

 

nevilledhamsiri
Specialist
Specialist
Author

Appreciate if this is looked in to by some one.

Thanks

Neville