topic Need Help for chart in QlikView

Need Help for chart

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

I am using scatter chart. I am using 4 expressions in that 2 expressions grouped using as cyclic group.

I have the data for 12 months. But my requirement is to show one month at a time like either cyclic group or in list box i need to show the chart April for now but they need to select if they want to see the previous months data. Can i know the expression to show only one month at a time.

I have month name as dimension. expressions are Sum(rowno()),Sum(hrs) and Sum(hrs)>2. I need to show in the same chart one month at atime.

can any one help on this?

Re: Need Help for chart

isingh30 — Thu, 24 May 2018 13:53:50 GMT

Try this -

= Sum({<Month = {'April'}>}Sales)

Thank you!

Re: Need Help for chart

vvira1316 — Thu, 24 May 2018 14:02:17 GMT

Would it be based on month selection?

If so, a variable will have to be used for month selected and used in set analysis expression

Re: Need Help for chart

isingh30 — Thu, 24 May 2018 14:23:29 GMT

Vijay,

Can you show us?

Thank you!

Re: Need Help for chart

Anonymous — Thu, 24 May 2018 14:48:04 GMT

Hi Ishtdeep,

if you delcare Vfromdate and Vtodate as variables ,

you can use them in set analysis as follow

Sum( {$<SalesDate={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM- DD'))'}>} Value )

Re: Need Help for chart

isingh30 — Thu, 24 May 2018 14:52:13 GMT

Thank you

Re: Need Help for chart

qlikviewwizard — Thu, 24 May 2018 14:58:04 GMT

Hi,

Try like this.

Script:

Date(MonthStart(Date),'MMM-YY') as Month,

Expressions:

Sum( {$<Month={"$(=Date(Max(Month),'MMM-YY'))"}>} Amount )

Sum( {$<Month={"$(=Date(AddMonths(Max(Month),-1),'MMM-YY'))"}>} Amount )

https://community.qlik.com/blogs/qlikviewdesignblog/2015/09/28/dates-in-set-analysis

Re: Need Help for chart

vvira1316 — Thu, 24 May 2018 15:56:33 GMT

Hi,

Following link helped me earlier in one of my situation....

How to select a range of dates from list box