topic Re: Segment by Model size and price in QlikView

Segment by Model size and price

israrkhan — Thu, 20 Aug 2015 12:22:35 GMT

Hi Community,

i have an issue , creating segment of Product By Model_Size, And Quantity Sold..

i have to create buckets, on quantity, and price..

kindly look at attached sample..

if anyone could help me,

i will really appreciate it..

Many Thanks..

kindly ask me, i will explain in detail..'

i want to use dimension from Product Table. column name is Label, and want to see how much quantity and price sold on each bucket,

Re: Segment by Model size and price

israrkhan — Thu, 20 Aug 2015 13:15:37 GMT

ANYONE PLEASE...!

Re: Segment by Model size and price

vishsaggi — Thu, 20 Aug 2015 13:33:04 GMT

Hello Israr,

Could you please elaborate a little bit about your requirement.

Thanks,
V.

Re: Segment by Model size and price

sundarakumar — Thu, 20 Aug 2015 13:39:21 GMT

There is clearly a cartesian product happenin in the sellout table. All the dimension have linear data.

Please correct the data model.

-Sundar

Re: Segment by Model size and price

ogster1974 — Thu, 20 Aug 2015 13:58:01 GMT

Here you go hope this helps

put your data in a pivot table.

Product and label dimensdion on quantity and price measures.

Regards

Andy

Re: Segment by Model size and price

israrkhan — Thu, 20 Aug 2015 14:00:45 GMT

daer vishsaggi

if you see the data model, i have four tables, linked like below:

Bucket Table-->> Product Table --> Model Table -->> Transaction Table

i have range defined in the bucket table, minimum , maximum and label for the range.

i have to use Label from Bucket Table, as a dimension...

and i have to sum the quantity and Price from Transaction table,

and have to show the result in the pie chart on each bucket...

kindly have a look at bucket table...you will understand more...

many thanks

Re: Segment by Model size and price

israrkhan — Thu, 20 Aug 2015 14:04:27 GMT

Dear Sundar,

i changed the data i removed the join from Bucket table into Product Table..

kindly have a look on data model now...

kindly explain me a bit more, how to correct data model, what is mean by All the dimension have linear data??

can you please...help on it??

see the new attachment please...

Re: Segment by Model size and price

israrkhan — Thu, 20 Aug 2015 14:24:36 GMT

if you see, sum(sellout.qty) and sum(sellout.price) is repeating on each row in pivot table...

i want to see this result in pie chart, on each label column from bucket table...

many thanks