topic Re: Show all Dates on Chart in QlikView

Show all Dates on Chart

ivandrago — Mon, 26 Oct 2015 17:19:14 GMT

Hi,

I have the attached Bar chart on the Analysis sheet, I want this chart to show all the DateMonth's that are available, the issue I am having is that there is a Trigger on the Analysis Sheet that will pick the latest DateMonth so the chart changes because of this selection.

How do ignore this selection for this chart?

Thanks

Re: Show all Dates on Chart

sunny_talwar — Mon, 26 Oct 2015 17:20:26 GMT

Try this:

Sum({<DateMonth = >}Amount)

Re: Show all Dates on Chart

srchilukoori — Mon, 26 Oct 2015 17:21:25 GMT

Hi,

Use the following expression in the chart.

sum({1}Amount)

Re: Show all Dates on Chart

ivandrago — Mon, 26 Oct 2015 19:31:41 GMT

Hi, I've applied a few more filters but chart 1 is not showing all the months? Any ideas as to why?

Re: Show all Dates on Chart

sunny_talwar — Mon, 26 Oct 2015 19:35:15 GMT

Try this expression may be:

=If(Only({<DateMonth = >} Pick='JS'), Sum({<Type={'OFF'}, DateMonth = >} Amount),

If(Only({<DateMonth = >} Pick='JT'), Sum({<Type={'ON'}, DateMonth = >} Amount)))

Re: Show all Dates on Chart

ivandrago — Mon, 26 Oct 2015 20:02:52 GMT

Hi, So what does this actually do? As if I make other selections will it affect the chart?

Re: Show all Dates on Chart

sunny_talwar — Mon, 26 Oct 2015 20:55:05 GMT

The chart won't be impacted by any selection you make in DateMonth field. For all other selections, the chart will drill down. Are there other fields on which you don't want this chart to change? If you do then just add them next to DateMonth like this:

{<DateMonth = , Field2 = , Field3 =, Field4 =>}

Re: Show all Dates on Chart

ivandrago — Tue, 27 Oct 2015 00:04:49 GMT

‌thanks!