topic Re: Categorizing pivot table in QlikView

Categorizing pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following excel data in this format:

Books	Price
A	15
B	9
C	12
D	11
E	8

I am able to create a table in qlikview. However, I would like to know if I would be able to further categorize them into 'Expensive'>10, 'Cheap'<10 in Qlikview directly? eventually, I hope to create a pivot table which looks smth like this:

eventually, I hope that in my final pivot table, in order to find how cheap book A is, I would like to click the category 'cheap', followed by 'book A', to find the price of book A.

Row Labels

Cheap

Expensive

Re: Categorizing pivot table

varshavig12 — Mon, 13 Jun 2016 10:29:46 GMT

Create buckets

Re: Categorizing pivot table

varshavig12 — Mon, 13 Jun 2016 10:36:58 GMT

Dimension:

=if(Price>=10,'Expensive','Cheap')

=Books

Expression:

Price

Re: Categorizing pivot table

varshavig12 — Mon, 13 Jun 2016 10:40:04 GMT

Re: Categorizing pivot table

qlikview979 — Mon, 13 Jun 2016 11:34:46 GMT

Hi Try This,

T1:

load * Inline [

Books, Price

A, 15

B, 9

C, 12

D, 11

E, 8

];

NoConcatenate

T2:

load

Books,

Price,

if(Price>10,'Expensive','Cheap') as Final

Resident T1;

drop table T1;

Re: Categorizing pivot table

Mon, 13 Jun 2016 12:15:18 GMT

HI, thanks for replying, there seems to be an error.

i am supposed to type the above code in the script editor as follows right?

Load books,

Dimension:

=if(Price>=10,'Expensive','Cheap')

=Books

Expression:

Price

I will get an error.

Re: Categorizing pivot table

Mon, 13 Jun 2016 12:19:32 GMT

hi, thanks for replying. but i will get an unknown statement error.

Also, i will be dealing with big data, so i would not be able to key in t1. how should the code in this case then?

Re: Categorizing pivot table

Mon, 13 Jun 2016 12:21:54 GMT

it is something like this table though, just that books should be the second column, and the first column would be the if statement.