difference between start of month and current month in straight table

[savithri_n_s]

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

[sunny_talwar · Accepted solution]

You are looking for something like this?

[savithri_n_s]

Hi Sunny,

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

[sunny_talwar]

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

Best,

Sunny

[sunny_talwar]

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

[savithri_n_s]

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

[sunny_talwar]

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.