Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

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
beck110979
Valued Contributor III

Re: Presentation of Values from MonthDiff as Year, Month

The issue is solved

Solution: FromDate, ToDate in Master Calender

2 Replies
pradosh_thakur
Valued Contributor III

Re: Presentation of Values from MonthDiff as Year, Month

can you try something like wherever you are calculating the Monthdiff

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

regards

Pradosh

beck110979
Valued Contributor III

Re: Presentation of Values from MonthDiff as Year, Month

The issue is solved

Solution: FromDate, ToDate in Master Calender

Community Browser