topic How can i add Group field in attached expression (set analysis problem) in QlikView

How can i add Group field in attached expression (set analysis problem)

Thu, 12 May 2011 11:06:23 GMT

Hi Everyone,

The Below expression is written for working only individual fileds.

But my requirement is that i need to use Group instead of single field i.e; i need to have here GetCurrentField(BCgroup) where i highleted the expression in Red color and GetCurrentField(DEgroup) in Blue color.

Pls share your ideas on this issue.

=count({$<BCShotFlowIndexA={">=$(bcVar1)<=$(bcVar2)"}>+$<DepoBCPeakVacA={">=$(DeVar1)<=$(DeVar2)"}>} LensKey)

Thanks

How can i add Group field in attached expression (set analysis problem)

erichshiino — Thu, 12 May 2011 11:45:07 GMT

Hi,

You have to create a variable, for example vGroup

the content of vGroup is

=GetCurrentField([BCGroup])

On set analysis, you call it like this:

SUM( {<$(vGroup)={A}>} VALUE1)

That's the idea of the syntax, you just need to adapt to your values and make it to the second group as well.

What I do, in these cases, I create a straight table chart, with no dimension and put the expression there with no labels. When you write the expression, QV will put it as the header of a column and you can see if it evaluates your variables correctly.

Hope it helps,

Erich

How can i add Group field in attached expression (set analysis problem)

Thu, 12 May 2011 13:18:20 GMT

Hi Erich,

Thans for your reply,

Can you send the brief explanation or send the set analysis expressin to me how should i change the actual expression.

Thanks...

How can i add Group field in attached expression (set analysis problem)

erichshiino — Thu, 12 May 2011 13:50:53 GMT

Hi,

I think you are pretty close.

Create two variables

vGroupBC

the content will be:

=GetCurrentField([BCgroup])

vGroupDE

the content will be:

=GetCurrentField([DEGroup])

The expression will be:

=count({$<$(vGroupBC)={">=$(bcVar1)<=$(bcVar2)"}>+$<$(vGroupDE)={">=$(DeVar1)<=$(DeVar2)"}>} LensKey)

How can i add Group field in attached expression (set analysis problem)

christian77 — Thu, 12 May 2011 14:00:40 GMT

Hi:

Lets try this other:

1st: Create your group/groups

2nd: GetCurrentField(YourGroup)

3rd: if(GetCurrentField(YourGroup)=Field1, Expression1,

if(GetCurrentField(YourGroup)=Field2, Expression2, ...

and so on.

You´ll save the variable.

Notice that the color-sintax-algorithm is failing. Another bug of QV10. But it works anyway.

How can i add Group field in attached expression (set analysis problem)

Thu, 12 May 2011 14:33:02 GMT

Hi Erich,

Thanks for your reply,

Sorry what u send is not working..

if know any other solution please reply me...

Thanks..

How can i add Group field in attached expression (set analysis problem)

Thu, 12 May 2011 14:44:19 GMT

Hi Christian,

Thanks for your reply.

can you write the expression1 for me

If(GetCurrentField(Mygroup)=Field1,Expression1

Thanks,

How can i add Group field in attached expression (set analysis problem)

christian77 — Thu, 12 May 2011 15:06:28 GMT

Hi, ravikumar_ajzaas:

I don´t know exactly what you want, I posted only an idea that you could use.

Neither I use those kind of sets so complicated. I’m a simple guy.

I see you have two groups. Are there in the same table?

GetCurrentField(BCgroup) gives you the current field that is showing in BCgroup. It can be only one, since it changes in the whole doc, and it works even if the table or the object does not contain that group.

I´d divide your set in two parts:

=count({$<BCShotFlowIndexA={">=$(bcVar1)<=$(bcVar2)"}> LensKey }

count({$<DepoBCPeakVacA={">=$(DeVar1)<=$(DeVar2)"}>} LensKey)

Now we have it easier.

If(GetCurrentField(BCgroup)=Field1, count({$<BCShotFlowIndexA={">=$(bcVar1)<=$(bcVar2)"}> LensKey }) )

If(GetCurrentField(DEgroup)=Field2,

count({$<DepoBCPeakVacA={">=$(DeVar1)<=$(DeVar2)"}>} LensKey) )

Are we approaching?

How can i add Group field in attached expression (set analysis problem)

erichshiino — Thu, 12 May 2011 15:28:40 GMT

Hi, Cristian. I can be complicated to break that set analysis into a sum of two expression.

If you do you can count the same registers twice

That set analysis solve the overlap between sets of registers.

ravikumar_ajzaas, did you include the "=" on the variable content?

What do you get when you put those variables on a text box?

How can i add Group field in attached expression (set analysis problem)

Thu, 12 May 2011 15:38:24 GMT

Hi Christian,

Thanks for your reply

But this is not working.

If you have any other solution reply me...

Thanks....

Re: How can i add Group field in attached expression (set analysis problem)

erichshiino — Thu, 12 May 2011 15:46:46 GMT

Hi,

I created a sample app with my suggestion

Hope it helps,

Erich

How can i add Group field in attached expression (set analysis problem)

Fri, 13 May 2011 04:58:05 GMT

Hi Erich,

Thanks for your amazing response . The attachment of your varGroup.qvw is unable to open in my system because i am having Qlikview10.0 trial version.

Is there any other way to reach your solution to me.

Thanks...

Re: How can i add Group field in attached expression (set analysis problem)

christian77 — Fri, 13 May 2011 07:10:38 GMT

Hi Erich:

Look at your file a little retouched by me.

Now I know how to attach a file.

The new site is looking good but I need to learn how to use it correctly.

How can i add Group field in attached expression (set analysis problem)

Fri, 13 May 2011 16:35:12 GMT

Hi Erich,

Thanks for your reply

The idea to bind the group data by taking variables and using those variables instead of groups is excellent

and it is working well.

Thanks...