topic Re: expression help - urgent plsss in QlikView

expression help - urgent plsss

Fri, 04 Dec 2015 14:42:22 GMT

Hi Experts,

i have attached sample qvw.

in that i have different branches. i need to rank the branches on three categories separately and then total of these three ranks gives total points.

finally, i have to rank for this total points.

when considering monthly selection, it works fine.

but when a quarter is selected, the total points are not changing.

eventhough a quarter is selected, it gives monthly total points.

My requirement is to get branch's total points alone for quarter.

how can i do this.

pls help me.

Marcio_Campestrini — Fri, 04 Dec 2015 15:07:23 GMT

Hi Prrajendran

Please post an example with your chart.

Márcio

Fri, 04 Dec 2015 15:09:29 GMT

Hi Marcio,

Pivot table is there in the sample.

just click clear after opening the qvw & help me pls

Fri, 04 Dec 2015 16:11:19 GMT

pls someone give suggestions

Marcio_Campestrini — Mon, 31 Oct 2016 18:55:42 GMT

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

ramasaisaksoft — Tue, 01 Nov 2016 07:50:57 GMT

Hi Rajendran,

i am unable to find your attachment.

as per my understanding

For you better object is Pivot table only

you said issue with quarter filter can u please select Quarters in list box and un-select that time Months list box.

and please specify your expression also so that we will know how u fallowed aggregation at expression level.