Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Karim_Khan
Contributor III

how to get check if the value is present in previous month in qlikview at script level

Hi Team,

    I have requirement in which i have to show the purchase and sales of the value.

Scenario one:

  If some values are already purchased in previous then it should not be consider in current month

Scenario two:

  If some values are not purchased in previous then it should be consider in current month

   Need to implement this logic in script level/Expression any one?

Regards,

Karim Khan

2 Replies
ahmar811
Contributor III

Re: how to get check if the value is present in previous month in qlikview at script level

Hi,

Can you please share some sample data as per your requirement then we will try to understand what you really want.

Regards

Ahmar

shiveshsingh
Honored Contributor

Re: how to get check if the value is present in previous month in qlikview at script level

You can use exists or previous function to meet your requirement. Can you share some data to work upon?