topic Re: Total Up in QlikView

Total Up

upaliwije — Thu, 24 Aug 2017 05:33:28 GMT

Hi Friends

I have in my QV doc the following Pivot table of course prepared with help of you.

I want to modify this report show subtotal then the days total and grand total. My requirement is shown below

If this is possible kindly advise me how to do it. I also attach sample QV doc H/w

Re: Total Up

Anil_Babu_Samineni — Thu, 24 Aug 2017 05:54:39 GMT

May be this?

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))

Re: Total Up

kaushiknsolanki — Thu, 24 Aug 2017 06:18:19 GMT

Try this.

It will allow you to set the date.

Regards,

Kaushik Solanki

Re: Total Up

upaliwije — Thu, 24 Aug 2017 06:18:50 GMT

Hi Anil,

Thanks a lot for your reply. I want a little thing clarified

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))

The above expression works well but since "Total Upto 21-Aug-2017" is hard coded It wont change with selection of due date

I have modified the expression but it does not work

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&max(DUE_DATE), Date(DUE_DATE,'DD-MMM-YY'))

Pls correct my expression

Re: Total Up

Anil_Babu_Samineni — Thu, 24 Aug 2017 07:09:56 GMT

I am sorry, I can't help y due to traveling till Tuesday.. May be offer you

Re: Total Up

tresB — Thu, 24 Aug 2017 07:19:00 GMT

Try with total keyword, like:

..'Total Upto'& Date(max(total DUE_DATE)-1)..

Re: Total Up

upaliwije — Thu, 24 Aug 2017 07:28:04 GMT

It works

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&'-'& date(max(TOTAL DUE_DATE,'DD-MMM-YY')-1), Date(DUE_DATE,'DD-MMM-YY'))

only thing date appear as

Total Upto-8/20/2017

I want it to be

Total Upto-20-Aug-2017

Pls help

Re: Total Up

tresB — Thu, 24 Aug 2017 07:32:47 GMT

Use format code in date() like:

..'Total Upto'& Date(max(total DUE_DATE)-1, 'DD-MMM-YYYY')..

Re: Total Up

upaliwije — Thu, 24 Aug 2017 07:38:47 GMT

Thanks It works

Re: Total Up

upaliwije — Thu, 24 Aug 2017 07:43:46 GMT

Sorry,

Look forward to your help after your travel