Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Guidance need to best way to desgin my data model

Hi All,

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

 

Main Seller TransIDOrder#Sub Seller TransID
XX1ABC01XX1
XX1ABC02XX1
XX1ABC03XX2
XX1ABC04XX2
XX1ABC05XX2
XX2ABC06XX1
XX2ABC07XX3
XX2ABC08XX3

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

2 Replies
settu_periasamy
Master III
Master III

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#)

srinivasa1
Creator II
Creator II
Author

Thanks Settu,

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

Thx