Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hopkinsc
Valued Contributor II

Expression to show last week figures

Hi, i am trying to create a chart showing me the total waste by region for the last complete week.

I already have a last week field - CAL_LASTWEEK and my region field is BDANAME. It needs to be for a specific set of customers = RETAILGROUP and the retail group is OWN STORES and lastly it needs to show all waste, my waste field is [STORE STOCK MOVEMENT CODE] which has 20+ codes, i only want it to show codes 3, 5  and 16.

So to summarise...

My fields are:

CAL_LASTWEEK

BDANAME

RETAILGROUP (which has several groups, i only want OWN STORES)

[STORE STOCK MOVEMENT CODE] (but the only codes i want are 3, 5 and 16.

Can anyone help please?

Tags (3)
1 Reply
hopkinsc
Valued Contributor II

Expression to show last week figures

Morning everyone, any ideas on this?

Community Browser