Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Simply give how to do ytd,MTD and all

Hello All,

 can you give me the explanation and expression for the below queries using of set analysis & without setanalysis .

Do it all in one QVW and share with me.

1 how to get YTD by customer and region wise ( if we can have 1 or 2 dimension)

2.write the expression to get the MTD sales using set analysis and without set analysis

3.write the expression to get the QTD sales using set analysis and without set analysis

4.I can have the 10 filters like as country, region and etc but i need to show only the country selection criteria in UI(whats the expression and whats the function)

5.What are the issues and challenges you have faced along with set analysis in your project. Give me lot of scenarios here plz

 

Regards,

Sonysree

Labels (1)
1 Reply
Highlighted
Master II
Master II

Re: Simply give how to do ytd,MTD and all

Hi Sonysree,

We can help you by writing expression and give it to you but that's not really going to help you. The community has a lot of articles regarding YTD,MTD etc. I would encourage you to search. Once you start reading and using them you will figure out yourself. I am not sure if anyone has the time to put it in 1 qvw and give it to you ready made or not, BUT if you start searching it will help you for sure.

Happy Learning.

Regards
Pradosh
Learning never stops.