topic Re: Dimensionality in QlikView

Dimensionality

vijetas42 — Thu, 30 Jun 2016 07:43:20 GMT

Hi all,

Can any one suggest any solution for below scenario,

I have used Dimensionality() in pivot table to hide my repetative(same) values for multiple row and displayed it only in total row and added partial sum on column which is at 1st position in table,but when i move column to some other position all total values goes blank

Thanks,

Vijeta

Re: Dimensionality

Anonymous — Thu, 30 Jun 2016 08:08:56 GMT

go and change/check your expression where you have written dimensionality() function.

--Anant

Re: Dimensionality

qliksus — Thu, 30 Jun 2016 08:18:13 GMT

Can you attach some sample files ? or Post What is your expression ?

Re: Dimensionality

vijetas42 — Thu, 30 Jun 2016 09:15:43 GMT

I have expression like this,if(dimensionality()=1 and currency='gbp',sum(sales),if(dimensionality()=1 and currency='eur',sum(sales)/exch_rate))

and i have written dimensionality in expression because,

I am having data like this,

Proj_def Vendor_name sales

P1 v1 2500000

v2 2500000

so, in this data i want to show ,

Proj_def Vendor_name sales

P1 v1

Total 2500000

Re: Dimensionality

Anonymous — Thu, 30 Jun 2016 11:29:56 GMT

how could using partial sum hide repetitive values actuall it sum of multiple rows and display a partial sum

for each categaory , can you go back and revert back to same and check all partial sums,

also if you have multiples column then that means you need to use

pick( dimensionalty()+ 1,yourExpr , AGGR ( YourExpr,column1 ),AGGR(YourExpr,Column1,Column2 )

so if only if none column is expanded in Pivot table then partial sum will be on first column

as soon as you click + and if two column is visble that means you need aggr on two dimensions so

AGGR(YourExpr,Column1,Column2 )

--Anant