topic Re: Urgent help. Thanks in QlikView

Urgent help. Thanks

n1ef5ng1 — Tue, 07 May 2013 09:54:59 GMT

Hi guys,

As above image, my dimension is month and my expression consist of (blank) and YTD

However my desire output is to show (blank) values monthly and YTD value on the last month that the user click

meaning

Feb March April

value value value YTD(Apr)

instead of

value YTD(feb) value YTD(march) value (YTD April)

value denots (blank)

thanks alot

Re: Urgent help. Thanks

sujeetsingh — Tue, 07 May 2013 10:02:56 GMT

Hi just write on your expression if() according to the current selection.

Post a sample

Re: Urgent help. Thanks

giakoum — Tue, 07 May 2013 10:04:35 GMT

"value on the last month that the user click"

that I do not understand. You mean that if the user selects a range of month you want to show the value of each month in one column and the value of all selected months in the next column?

Re: Urgent help. Thanks

n1ef5ng1 — Tue, 07 May 2013 10:05:11 GMT

I am using personal edition, can't read too

Re: Urgent help. Thanks

sujeetsingh — Tue, 07 May 2013 10:07:31 GMT

Better you explain your stuff again in simple words

Re: Urgent help. Thanks

n1ef5ng1 — Tue, 07 May 2013 10:11:50 GMT

ok let me rephrase,

My dimension include monthly, expression is the value and YTD

Referring to the picture i have attached earlier, I would like my desire output to have the YTD to remove on Feb and March. YTD will only show on the latest month, in this case, it is April.

I hope this will help to understand the problem better

Re: Urgent help. Thanks

giakoum — Tue, 07 May 2013 10:18:47 GMT

Then why don't you just create a total from the presentation tab?

Re: Urgent help. Thanks

sujeetsingh — Tue, 07 May 2013 10:19:37 GMT

Seee this

Re: Urgent help. Thanks

n1ef5ng1 — Tue, 07 May 2013 10:21:15 GMT

i can view, am using personal edition. sorry about that

Re: Urgent help. Thanks

n1ef5ng1 — Tue, 07 May 2013 10:21:36 GMT

I can't. the YTD has a different set of formula to derive the value