Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

difference between start of month and current month in straight table

Hi Team,

Can you Please help me to get the data as per the sample attached in excel sheet(book1) in dashboard 3 of qlik view in straight table?

Formulas for the metrics are in dashboard2

I want the Current month name to change dynamically based on latest date.

And start of the month is always sept 2017

1 Solution

Accepted Solutions
Highlighted

Re: difference between start of month and current month in straight table

You are looking for something like this?

Capture.PNG

View solution in original post

6 Replies
Highlighted

Re: difference between start of month and current month in straight table

You are looking for something like this?

Capture.PNG

View solution in original post

Highlighted
Contributor III
Contributor III

Re: difference between start of month and current month in straight table

Hi Sunny,

Excellent. Its helps me. I appreciate your help:)

Highlighted

Re: difference between start of month and current month in straight table

Great, please close the thread by marking the correct response.

Best,

Sunny

Highlighted

Re: difference between start of month and current month in straight table

I see you never close your threads, please take time to give back to the community as we have spent time to help you out.

Qlik Community Tip: Marking Replies as Correct or Helpful

Highlighted
Contributor III
Contributor III

Re: difference between start of month and current month in straight table

Hi Sunny,

Under actions. If i mark helpful is that the way i close the thread?

I used to do this i got message saying you are marking your questions as helpful by mistake

Can you please me?i will ensure it is closed

Highlighted

Re: difference between start of month and current month in straight table

Right now you marked this thread as 'Assumed Answer', but instead if you got a correct response, you can mark a response as correct by select the green 'Correct Answer' button that you will see under all the responses. Based on whichever answer was correct, you can mark the green button under it.

Example of how it looks like.

Capture.PNG