topic Re: Line chart compare PY no need to show last week in QlikView

Line chart compare PY no need to show last week

panwipa2528 — Thu, 08 Feb 2018 02:46:28 GMT

I have line chart as attach file, it's compare PY sale.
How should I do if I don't need to show week 52 .

Re: Line chart compare PY no need to show last week

tresB — Thu, 08 Feb 2018 04:45:09 GMT

May be use calculated dimension.

=If(Week<52, Week)

Re: Line chart compare PY no need to show last week

raman_rastogi — Thu, 08 Feb 2018 04:45:41 GMT

Panwipa

You can restrict Week 52 from your dimension

EX- If(Week<>52,Week)

And Suppress Null values

Raman

Re: Line chart compare PY no need to show last week

tresB — Thu, 08 Feb 2018 04:47:30 GMT

Or, if your 'last week' is not really last week in the week field but based on data availability, you might use set analysis in the expressions. For specific help, try to share a sample qvw.

Re: Line chart compare PY no need to show last week

panwipa2528 — Thu, 08 Feb 2018 05:01:08 GMT

Thank you

Re: Line chart compare PY no need to show last week

panwipa2528 — Thu, 08 Feb 2018 05:01:20 GMT

Thank you