Discussion Board for collaboration related to QlikView App Development.
i want make this count in pivot table:
if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM))))))
My problem is that for ID=FIRST_ID i don't want make the control by row but by the column.
So for example if the table is that
i want count 4 item for BOX1 because there are 4 FIRST_ID equal to ID of BOX1.
Can you Help me? PS: i don't know i fixed value for the ID because it changes for every ITEM
if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM)))))),ITEM)
us only() function in this case .
can you send a sample file ?
USE THE LITTLE TABLE... I CANNOT GIVE THIS DATA
Check this app