Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
Not applicable

Weekly order comparisons

Hi All,

wonder if you could help I am looking to produce a chart

I want the chart to display customer name and show there weekly trading so there sales amount and there order amount. and see if there is a spike within the month where they are sending more orders for example week one is quiet but week 3 and 4 they are placing a unachievable amount of orders.

but I only want this chart to display where a variable is set on there total sales revenue a month is above a set amount for example I can put in £50,000 and above and it will filter the chart with the required info

what would be the best way to do this? I currently hold the week number in my data

thanks in advance

Jase

1 Reply

Re: Weekly order comparisons

please post sample data and expected result

Community Browser