topic Re: Comparing self with Others in QlikView

Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:07:49 GMT

Hi all,

I want to compare the employee with some other employee in same chart. In that case, both should show in same time which can be in different color.

Always main should appear when we are comparing with some other group. Please help me the same how to achieve this.

Thanks

Nisha loganathan

Re: Comparing self with Others

anbu1984 — Thu, 30 Oct 2014 06:11:37 GMT

Can you provide sample input and expected output

Re: Comparing self with Others

vardhancse — Thu, 30 Oct 2014 06:13:22 GMT

in the chart expressions, we can create one expression like condition is if(expression_1=expression_2,'True',False')

So the in created expression, we can see the status

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:14:17 GMT

I think you should use Alternate states for this.

Provide a sample , so that we can help out in better way

Re: Comparing self with Others

vikasmahajan — Thu, 30 Oct 2014 06:14:48 GMT

Hii Nisha,

I think you need to implement comprehensive Analysis PFA documentation and how to implement the same.

Vikas

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:33:31 GMT

Hi all,

Thanks for your reply.

Hereby i attached the sample one. Please help me out how to achieve the same. I have tried a lot but couldnt find the solution.

Thanks,

Nisha loganathan

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:43:19 GMT

HI anbu chaliyan,

Thanks for your rpely.

I attached the sample. Please check the same

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:44:16 GMT

Hi Nitin,

I attached the sample. Please look at the same

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:45:11 GMT

Hi Vikas,

Thanks for your reply.

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 06:55:42 GMT

I saw your App,

What I understood,

You have givencondition,

if(GINP=$(vGIN),red(),blue())

its working fine.

As you can see, when you selected GIN as 1251768,

and if you are going to select any group then the selected group should be having GINP similar to GIN, then only it will show a red color dot else only blue ones will be shown..........

Do you want to fix red color, ?????

as if you selected GIN=1251768, it should always remain there comparing others also

?????????????

Re: Comparing self with Others

jagan — Thu, 30 Oct 2014 07:00:28 GMT

Hi Nisha,

Download Qlikview file from this link and check the Product Grouping tab

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

Hope it helps you.

Regards,

Jagan.

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 07:04:55 GMT

Hi Nitin,

Thanks for your reply.

For example, If am selecting one gin 1251768, that time it will show in red color. since we are giving condition like

if(GINP=$(vGIN),red(),blue()). Then in peer selection multibox i will select some other group, that time red color is disappearing. But it should not be like that. That selected GIN 1251768 should show in red when am selecting employee group and other things in peer selection multibox which should show in blue color. Condition which we are giving if(GINP=$(vGIN),red(),blue()). is problem.

Thanks,

NIsha loganthan

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 07:07:52 GMT

Hi,

Gin 1251768 belong to HC Mobile group , But in peer selection will compare with some other group like HC Commuter.

That time selected gin should show in red color always should appear. Other things should be in blue color

Re: Comparing self with Others

Thu, 30 Oct 2014 07:18:27 GMT

in creation of variable vGIN, can you use getFieldSelection(GIN) and check for the result

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 07:22:09 GMT

Hi,

Thanks for your reply. No its not working. Same problem remains

Thanks,

NIsha loganathan

Re: Comparing self with Others

Thu, 30 Oct 2014 08:34:41 GMT

Hi Nisha,

Its showing red color for particular GIN, if you selected peer group also...

Re: Comparing self with Others

jagan — Thu, 30 Oct 2014 08:59:43 GMT

Hi,

In variable vGIN you are using, =GIN and in expression you are comparing it with GINP

if(GINP=$(vGIN),red(),blue())

Is GIN and GINP are same?

or by mistake you give GINP instead of GIN?

Check this expression

=if(GIN=$(vGIN),red(),blue())

or I think it is hiding, if you select the same in GINP (1251768) then you can see the red color.

Regards,

jagan.

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 09:13:01 GMT

HI,

Thanks for your reply.

Gin and GINP is different . (both having same field values, just we are comparing one employee with other employee) I have to select the GIN, then am going to compare that gin with GINP. For EX:1251768 belongs to HC mobile group, That time it will show it in red color, others will be in blue color. In peer selection multibox will be for GINP, In that if am selecting some other employee group like HC commuter, That time Selected GIN 1251768 should be in red color, others should be in blue color. but as you can see after selecting employee group in peer selection box red color disappears. But it should not disappear when am comparing with GINP. Please help me how to achieve this.

Thanks,

Nisha loganathan

Re: Comparing self with Others

Anonymous — Thu, 30 Oct 2014 09:19:48 GMT

Hi,

1251768 GIN belongs to HC mobile, When we are comparing this group with some other group, We have to select some other group except HC mobile. So in this case if am selecting employee group in peer selection multibox other than HC mobile, That time red color disappears.

Thanks,

Nisha .l

Re: Comparing self with Others

jagan — Thu, 30 Oct 2014 09:34:58 GMT

Hi,

I think the red bubble is hiding, if you select the same in GINP (1251768) then you can see the red color.

Regards,

Jagan.