topic Re: About QlikView Cross Data in QlikView

About QlikView Cross Data

Mon, 25 Jul 2011 08:41:40 GMT

Hi all

I need to just show the data whose price was in different (more than 2) departments under the same product_num and the same dealer,I've tried many ways to realize it, including using total<> function in expressions, but it is far from what i want, anyone else has any exprience or good ideas to help me ? Thanks a lot.

The green line is what i want, the red line should be hided.

About QlikView Cross Data

lironbaram — Mon, 25 Jul 2011 08:45:34 GMT

hei

you didn't attach anything

About QlikView Cross Data

kaushiknsolanki — Mon, 25 Jul 2011 08:46:45 GMT

Hi,

Can you please explore your problem.

and there is not image, as you said (The green line is what i want, the red line should be hided.)

Regards,

Kaushik Solanki

About QlikView Cross Data

Mon, 25 Jul 2011 09:02:12 GMT

The example is what i want to realize in qlikview. Thanks

About QlikView Cross Data

kaushiknsolanki — Mon, 25 Jul 2011 09:07:48 GMT

Hi,

Use max(Unit Price) and max( Sqm Price) in expression.

Regards,

Kaushik Solanki

Re: About QlikView Cross Data

Tue, 26 Jul 2011 01:10:01 GMT

Hi, Solanki:

Thanks for your help, but you may misunderstand my words.

In the picture, ESE-->04298 just has price in only one department and it should be removed, the same as SHILI-->04298, TEAM-->04298.

And others should be reserved.

Re: About QlikView Cross Data

kaushiknsolanki — Tue, 26 Jul 2011 06:37:07 GMT

Hi,

Please have a look at the attached document.

Hope this is what you want.

If not then please do explain in detail.

Regards,

Kaushik Solanki

About QlikView Cross Data

Tue, 26 Jul 2011 07:40:40 GMT

Hi ,Solanki:

Thanks for your help, it's just what i want.

Best Regards.