topic Re: Dynamic Month as calculate dimension in QlikView

Dynamic Month as calculate dimension

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

Hello,

I was stuck with one problem, I don't know how to create dynamic calculate dimension. Like you see image, I want to create dimension based od selected date:

the expression for Month = Date={">$(=Date(Max(Date-30)))<=$(=Max(Date))"}

the expression for Month -1 = Date={">$(=Date(Max(Date-60)))<=$(=Date(Max(Date-30)))"}

the expression for Month -2 = Date={">$(=Date(Max(Date-90)))<=$(=Date(Max(Date-60)))"}

the expression for Month -3 = Date={">$(=Date(Max(Date-120)))<=$(=Date(Max(Date-90)))"}

the expression for Month -4 = Date={">$(=Date(Max(Date-150)))<=$(=Date(Max(Date-120)))"}

the expression for Month -5 = Date={">$(=Date(Max(Date-180)))<=$(=Date(Max(Date-150)))"}

Is it possible to create a dynamic month dimension?

Re: Dynamic Month as calculate dimension

sunny_talwar — Tue, 23 May 2017 15:50:23 GMT

May be this

If(Date > (Max(TOTAL Date) - 30) and Date <= (Max(TOTAL Date)), Dual('Month', 1),

If(Date > (Max(TOTAL Date) - 60) and Date <= (Max(TOTAL Date) - 30), Dual('Month - 1', 2),

If(Date > (Max(TOTAL Date) - 90) and Date <= (Max(TOTAL Date) - 60), Dual('Month - 2', 3),

If(Date > (Max(TOTAL Date) - 120) and Date <= (Max(TOTAL Date) - 90), Dual('Month - 3', 4),

If(Date > (Max(TOTAL Date) - 150) and Date <= (Max(TOTAL Date) - 120), Dual('Month - 4', 5),

If(Date > (Max(TOTAL Date) - 180) and Date <= (Max(TOTAL Date) - 150), Dual('Month - 5', 6)))))))

Re: Dynamic Month as calculate dimension

Anonymous — Wed, 24 May 2017 07:23:23 GMT

Yes, I have now "special dimension" but bars on the graph are not aligned to the middle. On the graph you see 7 expressions, how to move bars on middle of dimension?

Regards

Jacek.

Re: Dynamic Month as calculate dimension

kamal_sanguri — Wed, 24 May 2017 07:29:52 GMT

Try changing the orientation of 'X' axis label this way.

Re: Dynamic Month as calculate dimension

Anonymous — Wed, 24 May 2017 07:39:54 GMT

Hello,

Still from a visual point of view it looks bad. Label is not under bar and the line is not from beginning to end of the chart.

Regards

Jacek.

Re: Dynamic Month as calculate dimension

kamal_sanguri — Wed, 24 May 2017 07:48:26 GMT

Also, if the previous solution doesn't work for you try this method.

First Uncheck the Show Legend check box to turn off the 'X' axis labels on chart.

Then, Add text which will be your labels for 'X' axis.

the newly added text would appear on TOP LEFT side of your chart

Now click anywhere on chart to activate it and then press CTRL + SHIFT and you will see a red line around different objects in text

Now, Keep pressing CTRL + SHIFT and now you can drag this text box anywhere you want. You can then add more labels and put them at right place using this method.

Re: Dynamic Month as calculate dimension

Wed, 24 May 2017 07:50:51 GMT

Check if changing the style from grouped to stacked helps.

Cheers,

rohan

Re: Dynamic Month as calculate dimension

Anonymous — Wed, 24 May 2017 08:18:33 GMT

Super trick. Thank you for your help. Big plus for you and Sunny.

Final effect:

Regards

Jacek.