topic Re: Pivot table not show year in QlikView

Pivot table not show year

penpayom — Tue, 07 Aug 2018 10:36:19 GMT

HI!

I don't understand ,why year in pivot table are '-' but year in table box are value ='2015'

what should I do?

arvind_patil — Tue, 07 Aug 2018 10:40:03 GMT

Hi Penpayom,

Kindly check Year_ITEm has value against Year.

check show null value check box and check.

Thanks,

Arvind Patil

mayankraoka — Tue, 07 Aug 2018 10:49:57 GMT

Hi Penpayom,

Please attached sample QVW if possible.This will help us to answer your query faster.

Regards,

Mayank

PrashantSangle — Tue, 07 Aug 2018 10:51:56 GMT

What is your expression in pivot table???

penpayom — Tue, 07 Aug 2018 11:26:59 GMT

=sum(aggr(Fabric_QTY*(ITEM_CONTAIN/100),YARN_ITEM,Year))

How i can used [DISTING] in my this code

PrashantSangle — Tue, 07 Aug 2018 12:25:21 GMT

Why are you using AGGR()

try below

sum(Fabric_QTY*(ITEM_CONTAIN/100))

try this,

sum(aggr(Sum(Fabric_QTY*(ITEM_CONTAIN/100)),YARN_ITEM,Year))

Regards,