topic Re: Help with 2 Issues in QlikView

Help with 2 Issues

Thu, 01 Dec 2011 11:20:42 GMT

Good morning,

I'm ussing a personal edition and I'm trying to build a pivot table to show the inventory accuracy, let me explain my two issues:

1.- I have a Oracle DB that have a fiel call Count Date in DD/MM/YYYY

I want to separate it in Days, Months and Year in order to use it like a Dimension, but I don't know how.

2.- In order to calculate the Inventory accuracy, i have 2 level to do it.

. For Item - I'm ussing two field "Stock in Sistem" and "Stock Count" and this work fine.

. For Item Family - I woul like to know how many Items are right, using

Count(DISTINCT(If(Stock in Sistem=Stock Count,Item))) This Work some time but not in all case.

see attached my app

Could someone help me with it please

rohit214 — Thu, 01 Dec 2011 11:41:32 GMT

try this

1)day(dateField)

year(dateField)

month(dateField)

2) If(Stock in Sistem=StockCount,Count(Distinct item),0)

may it helps you

please let me know

thanks

rohit

kamalqlik — Fri, 02 Dec 2011 09:25:18 GMT

Hi friend....you can applly the following logic

1.Day(Count Date) as Day

2.Month(Count Date) as Month

3.Year(Count Date) as Year

4.monthstart(Count Date) as Monthstart.

regards

kamal