Problem of matching

Wed, 21 Sep 2011 14:52:56 GMT

Hi all !

For an application, I need to reduce data but keeping the total result. Example :

Tab_Data :

Region	NetworkId	Date	Sale
1	1	jun.11	15
1	1	jul.11	64
1	2	jun.11	41
1	2	jul.11	12
2	1	jun.11	46
2	1	jul.11	23
2	2	jun.11	21
2	2	jul.11	41

If I reduce on Region = 1, the user can see his sale (15, 64, 41, 12) and the total country (263). He can't see details for Region 2.

So I create a new data island table :

Tab_Data_total :

Total_NetworkId	Total_Date	Total_Sale
1	jun.11	61
1	jul.11	87
2	jun.11	62
2	jul.11	53

I use dimensionality in my result table to display the details for user in NetworkId1 and the total in total line.

My problem is in my total expression. I wrote :

sum(if(Total_NetworkId=NetworkId AND Total_Date=Date, Total_Sale))

If Date correctly matching (for 1 or more selections) it doesn't work for NetworkId. I don't know why ! I use this type of expression many time to use data island table.

After a litle control with isnum(), i see that my field NetworkdId is a numerical field. But my new field Total_NetworkId not ! Do you think that's the explanation of my problem ?

I don't understand why QV transform this numerical field into something else in the new table. I try to force a numerical value for Total_NetworkId by using num(), but it doesn't work !

Thank you for your attention and many many thanks for help !!!

topic Problem of matching in QlikView

Problem of matching