topic Set Analysis in QlikView

Set Analysis

mario-sarkis — Sat, 27 Dec 2014 13:10:39 GMT

hey all,,

i have this Data :

Network	branch	Data
x	1	144
	2	155
	3	155
	4	166
y	5	16
	6	1666
	7	144
	8	16
	9	166
z	10	177
	11	133
	12	344
	13	132

need to show 2 pie chart:

1- market share of the branch in each Network (when i select a branch i need to see his market share in the term of other branches within the same network)

2-A second pie chart i need to show the market share of the branch in the term of all branches (when i select a branch i need to see the market share of a branch in term of other branches in all Networks)

What should i write as SET ANALYSIS in A PIE Chart in order to see these to conditions??

Thank you,

Re: Set Analysis

Gysbert_Wassenaar — Sat, 27 Dec 2014 14:16:04 GMT

See attached qvw.

Re: Set Analysis

mario-sarkis — Sun, 28 Dec 2014 09:54:23 GMT

Hey Thank you For your Reply can you send the qvw again cause i cannot see it..

thank you in advance @ Gysbert Wassenaar

Re: Set Analysis

divianjani — Sun, 28 Dec 2014 10:14:30 GMT

hi mario

have a field like "opened time" -> it's showing like this "'1.22:43:8.000'' s but my requirement need to display into MM:SS format can anyone help me soon

Re: Set Analysis

mario-sarkis — Sun, 28 Dec 2014 11:51:47 GMT

hi anjali i think u can use the interval function

interval#(opened time,'MM:SS')

Re: Set Analysis

divianjani — Wed, 29 Apr 2015 07:09:40 GMT

Hi Mario,

I need help from you

i have dimension as sales office and metric as Revenue, how ever I need to create a gauge chart for that?

how i need to display sales ofc wise revenue amount % in gauge chart?

I hope anybody can help me

Thanks & Regards

Re: Set Analysis

divianjani — Tue, 10 Nov 2015 07:57:55 GMT

you had clarified my doubt earlier thanks for that,
could you please help me for below one,

Could you please help me,I have an straight table expression like this,
if(Metrics='Approval rate' or Metrics='Activation Rate',num(Only({<Year={'=max(Year)'},Scenario={'Actual'},
Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value),'#,##0%'),
Only({<Year={'=max(Year)'},Scenario={'Actual'},Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value)); if(Metrics='Approval rate' or Metrics='Activation Rate',num(Only({<Year={'=max(Year)'},Scenario={'Actual'},
Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value),'#,##0%'),
Only({<Year={'=max(Year)'},Scenario={'Actual'},Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value));

it is working fine in the table, however I need put this expression in the scripting , can you show me how to do?