topic Re: How do I restrict data till current month in Bar chart? in QlikView

How do I restrict data till current month in Bar chart?

Naushad07 — Mon, 25 Mar 2019 07:19:31 GMT

Hi All,

I have a requirement where I have to display the bar chart till only the current month. Need help on how to achieve this functionality?.

Details:

I have Data from 2016 till 2020. But I want to restrict my bar chart to display till current month.

Re: How do I restrict data till current month in Bar chart?

Anil_Babu_Samineni — Mon, 25 Mar 2019 07:25:40 GMT

My preference would be, create Month field with integer and use formula like

Sum({<MonthNum = {"$('<=' & =Max(MonthNum))"}, Year={"$('<=' & =Max(Year))"}>} Sales)

Re: How do I restrict data till current month in Bar chart?

kaushiknsolanki — Mon, 25 Mar 2019 07:27:10 GMT

Hi,

you should use the set analysis for that.

Below is the example.

Sum({<Date = {"<=$(=Monthend(today()))"}>}Sales)

For more information on Set analysis, find below link.

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Regards,

Kaushik Solanki

Re: How do I restrict data till current month in Bar chart?

Shubham_Deshmukh — Mon, 25 Mar 2019 07:34:00 GMT

Hi @Naushad07 ,

You can restrict it using calculated dimension, edit your dimension like below (keep date format as per yours) :

=if(date(yourDateField,'dd/mm/yyyy')<date(MonthEnd(today()),'dd/mm/yyyy'),yourDateField)

OR use exp like this

=Sum({<yourDateField= {"<=$(=MonthEnd(today()))"}>}yourQuantity)

Re: How do I restrict data till current month in Bar chart?

Naushad07 — Mon, 25 Mar 2019 07:33:42 GMT

My current Expression is

Count({<SetAnalysis={'Condition1'}>}Distinct Projects)

I am taking Month in X axis..

I have tried the expression that you have suggested..looks like it doesn't work

Use SET analysis to restrict data till current month in Bar chart?

Vegar — Mon, 25 Mar 2019 07:39:48 GMT

Lets assume that your current expression is SUM(Amount) and that you got an
numeric YearMonth field that increase numerically by every month. E.g.
201901, 201902 OR created by monthName() function. Then you can do the
following.

Adjust your expression with set analysis.

Sum( {< YearMonth={"$(=max(YearMonth))"} >} Amount)

This expressive will calculate the amount for the latest yearmonth in your
selection/data.

Re: How do I restrict data till current month in Bar chart?

Naushad07 — Mon, 25 Mar 2019 08:50:56 GMT

I am using Month in X axis, Not Date. I am displaying Bar chart month over month

Re: How do I restrict data till current month in Bar chart?

kaushiknsolanki — Mon, 25 Mar 2019 08:53:16 GMT

It doesnt matter, your X axis could be month, but the Date filter used in set analysis, will filter month by default.

Try the given expression and you will see the difference.

Regards,

Kaushik Solanki