topic Need help in writing expression in QlikView

Need help in writing expression

Mon, 20 Feb 2012 11:58:30 GMT

Hello Guru's.

I am trying to create weekly report, when you see the below detail

Week,

# of overdue invoices(Count of overdue Invoices)

Sum overdue invoices (Sum of overdue invoices)

# of Invoices (Count of Invoices)

Sum of Invoices(Sum of Invoices)

as I am facing problem in Pivot table, if there is no data for a week, it has to display 0 for instance Week 6 has no data I need to dispaly week 6 has 0 in all columns.

In the database itself the week value is not written in the table, I tried like if Week is null or 0 the number and sum of invoice is 0 but its not working,

can anyone share their ideas.

secondly based on this value I trying to create a line chart if there is no data the lines should touch the 0 and then travel but its not working for me

WEEK	#Of Over Due Invoices	Sum of Over Due Invoices	# Of Invoices	Sum Of Invoices
1	10	9 257,19	10	9 257,19
2	9	4 807,19	9	4 807,19
3	11	8 862,58	11	8 862,58
4	10	5 896,55	10	5 896,55
5	9	4 807,19	9	4 807,19
7	2	8 621,99	4	14 501,99

Regards

Chriss

Need help in writing expression

CELAMBARASAN — Mon, 20 Feb 2012 12:09:47 GMT

Hi,

You should have data in a table to display in the dimensions.

So use below for week

WeekTable:

LOAD

RecNo() AS Week

AutoGenerate 52;

Then use all your expressions like below

=Alt(Expression,0)

Don't forget to uncheck the suppress zero values in the presentation tab.

Celambarasan

Need help in writing expression

Mon, 20 Feb 2012 12:58:37 GMT

Dear Celambarasan,

Thanks for your reply, as I have tried what you suggested, I have forgot to tell you one thing, actually I have checked the database the data which is not available for week 6 is for only one customer and rest of the customers had the values.

When I select this particular customer, the 6th week value is not there as I have given in the table its showing and more than I have tried using Load statement and the Alt() expressions, its not working.

Can you suggest me is that any other solution to do this..

Regards

Chriss

Need help in writing expression

CELAMBARASAN — Mon, 20 Feb 2012 13:04:00 GMT

Hi,

Have you Checked the Show all values in the Dimension tab?

Celambarasan

Re: Need help in writing expression

Mon, 20 Feb 2012 13:34:19 GMT

Dear Celambarasan,

Exactlly works but at the end "-" is coming, I need to avoid this hypen.

can you help me on this...

Regards

Chriss

Re: Need help in writing expression

CELAMBARASAN — Mon, 20 Feb 2012 13:39:15 GMT

Hi,

This displays due to Null value in the week field to hide that in the same Dimension tab check the Suppress when value is null option which is above the show all values.

Celambarasan

Re: Need help in writing expression

Mon, 20 Feb 2012 13:43:00 GMT

Dear Celambarasan,

Thanks a lot, its works............

Regards

Chriss