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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II
‎2014-06-16 08:08 AM

Dimension interval

hello

I have two expressions on a line chart

on the x-axis I want to show values that range from 0 till 12

How can I attain this?

Please advise

I can walk on water when it freezes
Labels (1)
Labels
1,937 Views
0 Likes
10 Replies
jonathandienst
Partner - Champion III
Partner - Champion III
‎2014-06-17 03:05 AM

In response to ali_hijazi

HI

How about:

    =(Year(DefectDate) - Year(SellDate)* 12 + (Month(DefectDate) - Month(SellDate))

    =(Year(FixDate) - Year(SellDate)* 12 + (Month(FixDate) - Month(SellDate))

It would be simpler if QV had a DateDiff function like SQL:)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
150 Views
0 Likes