topic Re: showing Weekly collection in QlikView

showing Weekly collection

narender123 — Thu, 27 Jun 2013 08:47:22 GMT

Hi All,

Give me some idea.

I have attached 2 screen shot.In 1st screen shot, shows this year current week collection and previous year current week collection which are running good for this year as well as for previous year.

But the problem starts when i select month and date of this month or another month,then it shows the collection only for that day of that month but i want for that day weekly collection with weekly dates.I have shown the problem in my 2nd print screen shot.In 2nd screen shot i have selected there

Year=2012 month=jan day=11

then it should show the week of 11jan2012 collection but it is showing only 11jan2012 collection means 12,13 ,14 ... are not there.I want that also..

I thing their is something wrong in my expression .

Thanks in advance.

Narender

Re: showing Weekly collection

jagan — Thu, 27 Jun 2013 08:58:18 GMT

Hi Narendar,

Try excluding the Day selection, by giving Day= in your expression

For example:

Sum({<Year={Some Value}, Month={Some Value}, Day=>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: showing Weekly collection

narender123 — Thu, 27 Jun 2013 09:22:48 GMT

Thanks Jagan.Its working.

Could you tell me something more about it.

if i add both expression(prevoius & current year) in single chart then result looks like as i shown in my attachment.

In attachemnt file it shows the prevoius year collection for previous year week day where current year shows 0 collection after prevoius year its start the current year week day collection where previous year week day collection shows 0.So what i have to do for this ???

Thanks

Re: showing Weekly collection

narender123 — Thu, 27 Jun 2013 09:51:49 GMT

By frezzing Day like "Day=" .Its not effect for that chart.But here in chart is effecting after freezzing it.How ?

Please tell me??

Because i heard that after freezing any filter ,filter will not effect that chart.

Thanks.

Re: showing Weekly collection

jagan — Thu, 27 Jun 2013 11:53:57 GMT

Hi,

By giving Day=, in your expression it excludes the selection of the Day dimension. We need to exclude because we need to override the selection to show current and previous year week data.

Regards,

Jagan.

Re: showing Weekly collection

jagan — Thu, 27 Jun 2013 11:55:07 GMT

Hi,

Combine 2 expressions into one expression, then you will get chart correctly.

Regards,

Jagan.

Re: showing Weekly collection

narender123 — Thu, 27 Jun 2013 12:19:10 GMT

Thank you Jagan .

Is it possible to show my report looks like this

WEEKLY REVENUE COLLECTION
14^th June	15^th June	16^th June	17^th June	18^th June	19^th June	20^th June
$339,252.03	$23,105.21	$149.14	$506,502.98	$511,347.33	$609,520.75	$766,880.61
TOTAL REVENUE COLLECTION						$2,756,758.05
TOTAL REVENUE COLLECTION 2012						$2,064,304.95

As i have made my report shown in attacment and i nt my report to look like above table.

Thanks.

Re: showing Weekly collection

jagan — Thu, 27 Jun 2013 12:41:49 GMT

Hi,

It is not possible in a single chart, below the chart, use labels or straight tables to display Total revenue calculation.

Hope this helps you.

Regards,

Jagan.