topic pivottable in QlikView

pivottable

Tue, 22 Nov 2011 10:10:09 GMT

Hello everyone,

I encountered a problem, I would like to have your helps.

I have a simple table as shown below (Table 1)

thanks for your helps

table1

I sould present the data in a pivot table (Table 2).

but I have to apply a condition in my table:

so if my amount is above 100, I display the number, but if it is less than 100 I juste display "No display" and also for the total line(table3)

Tue, 22 Nov 2011 10:24:04 GMT

Pls find attachment....

Regards,

Antony.

Tue, 22 Nov 2011 10:26:45 GMT

Hi, please find attached.

Tue, 22 Nov 2011 10:32:47 GMT

pls ignore my above attachment... attached the new one..

Hope it works for you....

Regards,

Antony.

Tue, 22 Nov 2011 10:41:07 GMT

Hi,

See the file.

Succes!

Tue, 22 Nov 2011 11:21:12 GMT

thanks for your replys