Guidance need to best way to desgin my data model

srinivasa1 — Fri, 11 Nov 2016 07:16:07 GMT

Hi All,

I have wired requirements to incorporate in my my data model and i have below requirements to achieve

Main Seller TransID	Order#	Sub Seller TransID
XX1	ABC01	XX1
XX1	ABC02	XX1
XX1	ABC03	XX2
XX1	ABC04	XX2
XX1	ABC05	XX2
XX2	ABC06	XX1
XX2	ABC07	XX3
XX2	ABC08	XX3

If I select Main Seller TransID=XX1 Then I wanted to do

count of Order# belongs to Main Seller TransID(#XX1) + Sub Seller TransID(#XX1)(5+3=8) and Same way in case I select Main Seller TransID XX2(ie 3+3=6)

See here Main Seller TransID has 5 Order and it and also Main Seller TransID(XX1) found Sub Seller TransID that’s (XX1 ) and it has 3 Order in that case wanted desgin my data model such way when I select Main Seller TransID(XX1) I need add order of Main Seller TransID(XX1)5 +3 Sub Seller TransID that’s (XX1 )

Attached Sample app and details for same.

Thanks in advance for any help on achieve this best way

Re: Guidance need to best way to desgin my data model

settu_periasamy — Fri, 11 Nov 2016 17:30:18 GMT

Create on Variable like

v1 : =Concat(DISTINCT chr(39)&[Main Seller TransID]&chr(39),',')

In the text box try the below expression

=Count(Order#) + Count({1<[Sub Seller TransID]={$(v1)}>}Order#)

Re: Guidance need to best way to desgin my data model

srinivasa1 — Fri, 11 Nov 2016 18:48:16 GMT

Thanks Settu,

Do you have any idea how I can achieve this in ETL script?

Thx

topic Re: Guidance need to best way to desgin my data model in QlikView

Guidance need to best way to desgin my data model

Re: Guidance need to best way to desgin my data model

Re: Guidance need to best way to desgin my data model