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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get data barcode if data is in this month and next month only?

How to get data barcode if data is in this month and next month only?

The example : if i selected MONTH_TRX = Feb, i only get data barcode on Feb in expression 1 (No. Barcode Feb 2012).

How is the second expression if i want to get data on March 2012 on expression 2 No. Barcode Mar 2012) ? I want to show data barcode from MONTH February only and this barcode match on March 2012.

Test.jpg

Thanks

2 Replies
Not applicable
Author

Hi Danny,

probably you can use a formula like this (assuming for the example that you use sum):

sum( {<MONTH_TRX={$(=Only(MONTH_TRX) + 1)}>} Barcode)

Cheers,

Martin

Not applicable
Author

Hi, Danny Hermawan

I wonder have you ever tried the following formula?

sum( {<MONTH_TRX={$(=Only(MONTH_TRX) + 1)}>} Barcode)

Did it work? When it comes barcode processing, I have another question.

I wonder what is the latest version of the Barcode Reader you were using? I am looking for a fine barcode scanner whose way of processing is simple and fast to help me read 128 barcode. It will be better if it offers free trials for users to check. Any suggestion will be appreciated. Thanks in advance.   

Best regards,

Pan