Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Veritcal reference line

Hello gurus

I needed a vertical reference line in my chart which is based on month/year dimension.

Before applying the vertical reference line the chart looked like so:

In order to get the vertical reference line I had to change the Dimension Axis to Continuous. But that changed the displayed values of the dimension and added a semi monthly grid. Here it is:

How can I format the Dimension to show MonthName (month and year as above) which is not in the Number formatting tab and how can I get rid of the "mid month" grid?

Thanks

Josh

13 Replies
maheshkuttappa
Creator II
Creator II

Can you post the QVW with sample data ?

jduenyas
Specialist
Specialist
Author

the app is way too large.

I will try to set a smaller sample

MarcoWedel

Hi,

seems to work with 'MMM YYYY' as date format:

QlikCommunity_Thread_231143_Pic1.JPG

QlikCommunity_Thread_231143_Pic2.JPG

hope this helps

regards

Marco

jduenyas
Specialist
Specialist
Author

Marco you are the best.

however why do I get a Mid Month grid?

Not applicable

Had the same problem just the other day. To fix it I replaced my SalesDate dimension with the following expression:

=Date(MonthStart(SalesDate),'MMM-YYYY')

The MonthStart function will convert all dates to the first day of the month. So, 7/15/2016 will become 7/1/2016, etc.

Will this work for you?

- Stan

Anil_Babu_Samineni

Give 50% of reference

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
stabben23
Partner - Master
Partner - Master

Hi,

from where does Your month/year Dimension comes from? is it from a calender or is the Field concatenated in a fact table With sales and Budget? This is probably datamodel related.

jduenyas
Specialist
Specialist
Author

Cannot because the Definition>Percentile is grayed out.

Thanks though

jduenyas
Specialist
Specialist
Author

The date is from the Calendar