Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
savithri_n_s
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
sunny_talwar

You are looking for something like this?

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

You are looking for something like this?

Capture.PNG

savithri_n_s
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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.

Capture.PNG