topic Re: Calendar in QlikView

Calendar

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a bar chart ...

I need to show total 13 bars (Jan,Feb,Mar,app,may,Jun,jul,Aug,sep,Oct,Nov,dec ,ytd)

Please need help to achieve this ...

In dimension iam using

Month field

And in expression iam using

Sun(sakes)*sum(expenses)/sum(profit)

Need your help expertise ..

Thanks in Advance

karthikoffi27se — Wed, 07 Feb 2018 04:37:04 GMT

Hi John

Format it using date function.

Date#(Date("Month field",'MMM'),'MMM') AS DateField

Use the above expression in chart and let me know what you get.

Many Thanks

Karthik

smilingjohn — Wed, 07 Feb 2018 04:44:23 GMT

Hi Karthik

I iam getting month against expression ...

Buy I need the last bat to display ytd ..which I am not able to get ...

I do have master calendar also ....and I have date field "date"

And it's format is MM-DD-YYYY