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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
‎2014-06-06 08:40 AM

how to compare two expressions dynamically

Hi All,

I am developing Inventory Adgeing report for that I am facing some problem. I have attached excel file:

In that Suppose I have Material A for that I am having Total BUM Qty : 1480.25 but Total BUM Output Qty is 10954.735,

So I want to compare BUM Qty and BUM Output Qty upto when BUM Qty is less than BUM Output Qty that records I want to capture.

In attached file I want Output qty and only red colour rows.QlikTech Admin

Preview file
40 KB
491 Views
0 Likes
3 Replies
its_anandrjs
MVP
MVP
‎2014-06-06 08:54 AM

Can you explain more what output you required for first 5 rows.

406 Views
0 Likes
Not applicable
‎2014-06-06 09:02 AM
Author

Dear Rupali,

Try the app attached.

Regards

Rahul

Output Qty.qvw
406 Views
0 Likes
Not applicable
‎2014-06-06 09:25 AM
Author

"So I want to compare BUM Qty and BUM Output Qty upto when BUM Qty is less than BUM Output Qty that records I want to capture."


Can you further explain what this means? I do not understand your requirement.

406 Views