Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem of matching

Hi all !

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

Tab_Data :

RegionNetworkIdDateSale
11jun.1115
11jul.1164
12jun.1141
12jul.1112
21jun.1146
21jul.1123
22jun.1121
22jul.1141

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_NetworkIdTotal_DateTotal_Sale
1jun.1161
1jul.1187
2jun.1162
2jul.1153

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 !!!

0 Replies