Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Presentation of Values from MonthDiff as Year, Month

Hi Folks,

i have a question,

i have the fields: Start, End, MonthDiff

for example:

Start,                     End,                     MonthDiff

06.10.2017          06.05.2019                    20

06.10.2017          06.10.2018                    13

if i splitt the amounts: 2,78 : 20 and 1,14 : 20

                                0,68 : 13 and 0,51 : 13

and have the following chart (see attached screenshot)

my issue:

how can i show below of my chart the date-values like: Okt 2017, Nov 2017 until Mai 2019  and  not 13, 8 , 20, 27?

does anybody have any ideas?

thanks a lot

Beck

1 Solution

Accepted Solutions
beck_bakytbek
Master
Master
Author

2 Replies
pradosh_thakur
Master II
Master II

can you try something like wherever you are calculating the Monthdiff

dual(Monthdiff expression ,date(End,'MMM-YYYY'))

regards

Pradosh

Learning never stops.
beck_bakytbek
Master
Master
Author

The issue is solved

Solution: FromDate, ToDate in Master Calender