Need Help for chart

[sweety0912]

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?

[isingh30]

Try this -

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

Thank you!

[vvira1316]

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

[isingh30]

Vijay,

Can you show us?

Thank you!

[Anonymous]

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 )

[isingh30]

Thank you

[qlikviewwizard]

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

[vvira1316]

Hi,

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

How to select a range of dates from list box