Sample Req

[soniasweety]

Hi all,

I am pretty new to Qlik .

I have  loaded some data into  Qvw.  but i want to achieve some  elements in  Qlik can anyone help me on this?

REQ:

• 1Current Year Sales, Last Year Sales and  YTD Sales growth
• We wish to identify the relation between the Sales Qty and Sales Value by each Product
• Sales trend by Year, Month, Week
• Analysis of Customers by Country and City,

Sample qvw attached

Thanks

Sony

[sunny_talwar]

You have provided very generic requirement? I think you need to provide more detailed information on what all things are you hoping to see for each of your requirement.

[soniasweety]

based on Order date i need to caluclate all these.

[soniasweety]

and  one more thing

easily filter the data by Year and  Month  based on both order Date and Order creation Date, Customer Country, Product Category and Product Name

[MK_QSL]

Hi,

If possible go through below link and try learning step by step.

New to QlikView Videos

Year-over-Year Comparisons

YTQ, QTD, MTD and WTD

[MK_QSL]

In short, you want this project to be finished by someone from community...

[soniasweety]

Its not like that... once it is done i can learn the exact solution right?   thats why.

[lironbaram]

hi

have a look at the attach example

hope it's helps you

[its_anandrjs · Accepted solution]

Try with some of this chart expression created for you for more you can learn by creating your self.

Regards

Anand

[soniasweety]

thanks anand.

how to achieve below this? 

• Sales trend by Year, Month, Week

  Analysis of Customers by Country and City