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: 
dhavalvyas
Contributor III
Contributor III

How to write Peek with if else condition for the expression

Hi,

I have raw data contain site_id,site live date and site close date respectively.

If same site_id will found for next site live date then it should add to count,i.e. now count is 2. but if same site_id found in site close date then it should subtract from count,i.e. its count is now 1

Can any one suggest how to write If Else condition with peek for the same ?

10 Replies
Anil_Babu_Samineni

Sure, Will do our best. May be explain from that image as case study ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful