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

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
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn 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
‎2012-09-14 05:55 AM

Row wise Calculation

I have two Tables Call

  • Stock table (Partno,Contract,Dateapplied,Qty)
  • Showroom stock Table (Partno,Contract,Historydate,INQty)

Stock Table Shows the summery of the show room Stock Table linkby Partno and Contract.I want to break down the Show room Stock Table to Time Periods(0-90/90-120/120-180/180-360/36). Also we want to build a set of records that shows the stock changes according to the time periods. For example

Total Stock - 52

     0-90 Time period

          Showroom stock table record

     90-120 Time period

          Showroom stock table record

I did this algorithm in Excel and the formula is- 'IF(C1>C3,C1-C3,C1)'. How can I break records as above in Qlickview?

ora.qvw
670 Views
0 Likes
1 Reply
Nicole-Smith
MVP
MVP
‎2012-09-14 02:01 PM

This post should give you what you're looking for:

http://community.qlik.com/message/213862#213862

462 Views
0 Likes