Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if statement in qlikview

how can we write this if statement in qlikview



If "Collateral or Scrip" = "Trades" And
If "Borrower or Lender" = "Lender" Then
Market Value = -Qty * Market Price Else
Market Value = Qty * Market Price

If "Collateral or Scrip" = "Collateral" and "Security ID" = "Cash"
Then If "Borrower or Lender" = "Borrower"
Market Value = -Qty Else
Market Value = Qty

ElseIf "Security ID" <> "Cash" and
"Borrower or Lender" = "Borrower" Then
Market Value = -Qty *  Market Price Else
Market Value = Qty * Market Price

3 Replies
MarcoWedel

‌please post sample application.

regards

Marco

CELAMBARASAN
Partner - Champion
Partner - Champion

May be like this

Load *,

If("Collateral or Scrip" = "Trades",

     If ("Borrower or Lender" = "Lender",

                -Qty * "Market Price",

               Qty * "Market Price"

     ),

     If( "Collateral or Scrip" = "Collateral" and "Security ID" = "Cash",

          If( "Borrower or Lender" = "Borrower",

                    -Qty,

                    Qty

          ),

          If( "Security ID" <> "Cash" and "Borrower or Lender" = "Borrower",

                    -Qty *  "Market Price",

                    Qty * "Market Price"

          )

     )

) AS Market Value

FROM Source;

effinty2112
Master
Master

Try this:

Pick(Match([Collateral or Scrip],'Trades','Collateral'),

//[Collateral or Scrip] ='Trades'

If([Borrower or Lender] = 'Lender',[Market Value] = -Qty * [Market Price], [Market Value] = Qty * [Market Price])

,

//[Collateral or Scrip] ='Collateral'

If([Security ID] = 'Cash',

If([Borrower or Lender] = 'Borrower', [Market Value] = -Qty, [Market Value] = Qty),

If([Borrower or Lender] = 'Borrower', [Market Value] = -Qty * [Market Price], [Market Value] = Qty * Market Price)