topic Re: Show only latest quarter data in piot table in QlikView

Show only latest quarter data in piot table

sundarakumar — Thu, 22 May 2014 16:34:33 GMT

Hi All,

PFA a sample app that I have bee working,

this is how my data is . My requirements is always show the latest quarter value at any time i.e

when I have all expanded show all data as such, when I expand it to only year level show me the data of the latest quarter alone(40,40,20) and when I didn't even expand it by year level, show me the data of the latest year and latest quarter... (20)...

I have managed to write an expression to make it work up to expression level.

if (max(qr)=4, sum({<qr={4}>}in),
if (max(qr)=3, sum({<qr={3}>}in),
if (max(qr)=2, sum({<qr={2}>}in),
if (max(qr)=1, sum({<qr={1}>}in), ))))

Please help me out to modify the expression or with a new expression for the requirement that will show me 20 if I have not expanded the pivot table by any level..

Thanks in advance.

-Sundar

Re: Show only latest quarter data in piot table

ashfaq_haseeb — Thu, 22 May 2014 17:03:40 GMT

Hi,

may be like this

Regards

ASHFAQ

Re: Show only latest quarter data in piot table

sundarakumar — Thu, 22 May 2014 17:08:15 GMT

Thanks for the reply Ashfaq. But I want to show all data if nothing is selected. I cannot hide the chart if no year is selected. It should show the latest quarter and latest year data according to the expansion that user make.

-Sundar

Re: Show only latest quarter data in piot table

dharmarasu — Fri, 23 May 2014 07:09:48 GMT

Hi sundarakumar,

U can try this..

in the dimension u want to add calculeted dimension for Quarter field...here u can restrict the quarter to max quarter..

Instead of qr field in Dimension add calculted dimension and write this..

=if(max(qr),qr)

Hope this helps...

Regards,

Dharmarasu M

Re: Show only latest quarter data in piot table

sundarakumar — Fri, 23 May 2014 07:13:01 GMT

Hi Dharma,

Thanks for the reply, That would restrict the Q1,2 and 3 at all times. I want so show user Q1,2,3, data when they expand it to quarter level.

-Sundar

Re: Show only latest quarter data in piot table

CELAMBARASAN — Fri, 23 May 2014 07:27:07 GMT

You could try with the Dimensionality function.

Kind of

if(Dimensionality()=2, Aggr(if(Max(Total<mg,yr> qr)=qr, Sum(in)), mg, yr, qr), Sum(in))

Re: Show only latest quarter data in piot table

dharmarasu — Fri, 23 May 2014 07:50:15 GMT

hi sundar...

try this...

in the expression,

check conditional and write the below script

=count(GetCurrentSelections(yr))=0

and expression is

= sum(in)

add another expression

=count(GetCurrentSelections(yr))=1

and expression is

=sum({<qr={$(=max(qr))}>}in)

hope this helps..

Regards,

Dharma

Re: Show only latest quarter data in piot table

sundarakumar — Mon, 26 May 2014 07:15:25 GMT

I resolved the issue with the dimensionality function that u have shared, thanks a lot

-Sundar