topic Re: qlikview formula to excel formula in QlikView

qlikview formula to excel formula

tripatiqv — Sat, 16 Nov 2024 20:44:41 GMT

Hi All,

I have 3 dimension serial no, State, Itemcategoryname and 14 expression in qlikview pivot table.

Now we are developing this report in nprinting and we need to write below formula in excel.

for expression 7 we are writing below formula in

if(Column(4)='0.00',0.00,(Column(4)/
if(Dimensionality()=2,sum(TOTAL WEIGHTINMT),
if(Dimensionality()=3,sum(TOTAL<STATE>WEIGHTINMT),
Sum(TOTAL<STATE,ITEMCATEGORYNAME> WEIGHTINMT))))*100)

Please help in writing this formula in excel

Re: qlikview formula to excel formula

Sergey_Shuklin — Mon, 03 Jun 2019 04:53:11 GMT

Hello!
Some data sample will give a hand with this task. Can you share a piece of data?

Re: qlikview formula to excel formula

tripatiqv — Tue, 04 Jun 2019 11:54:20 GMT

Dear

please find the sample qv application and sample excel data

I need to write current month % share.

Re: qlikview formula to excel formula

Sergey_Shuklin — Tue, 04 Jun 2019 12:38:19 GMT

Hello!

Please, check the attached file. I've added TOTAL row, for table without it - just exclude the outer IF-condition with CELL="TOTAL" check.