Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis to display similar fields as one field'

I am having  following tables

Fact:        

Brand Code,

Site_ID,

Sales

Site Brand Area:

Site_ID,

Site Brand Name,

Brand SQ.M.

Target:

Site_ID,

Site Brand Name,

Target/Sqm

Brand_Master:

Brand Code,

Brand

I would like to display, for Site_ID, Sales, and sum(Brand SQ.M.*Target/Sqm) where i want to use set analysis for Brand and Site Brand Name,

and I am using :

Sum(

{<[Brand] = {"=[Site Brand Name]=[Brand]"}>}

([Brand SQ.M.]*[Target/Sqm.])

cant work.

9 Replies
preminqlik
Specialist II
Specialist II

do one thing ... bring Brand code field for brand target table by applymap or left join ,

then concatenate brand target table with FACT on the bases of keeping the common field Brand Code 

rajat2392
Partner - Creator III
Partner - Creator III

Hi Vivian,

Try this script..

Sum(

{<[Brand] = {'$(=[Site Brand Name])'}>}

([Brand SQ.M.]*[Target/Sqm.])

)

Not applicable
Author

Hi,

Try this

Sum(

{<[Brand] =p( [Site Brand Name])>}

([Brand SQ.M.]*[Target/Sqm.])

)

Hope it may help....

Not applicable
Author

HI, Saranya,

It result in Total Target Amount. But not divided according to Brand.

Thank you

rajat2392
Partner - Creator III
Partner - Creator III

Hi Vivian,

Did you try this

Sum(

{<[Brand] = {'$(=[Site Brand Name])'}>}

([Brand SQ.M.]*[Target/Sqm.])

)

rajat2392
Partner - Creator III
Partner - Creator III

Can you provide you sample qvw please...

Not applicable
Author

Hi Vivan,

Try this expression with Aggr() like below:

sum(aggr(Sum(

{<[Brand] =p( [Site Brand Name])>}

([Brand SQ.M.]*[Target/Sqm.])

),[Brand]))

Hope it will help....

Not applicable
Author

HI Rajat.

thank you for your reply.

I have tried that before. It doesnt help me.

and I dont have sample data or qvw

thank you

Not applicable
Author

can u share your qvw file

tat will be easy to identify the prob.....