About QlikView Cross Data

[#1]

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.

[lironbaram]

hei

you didn't attach anything

[kaushiknsolanki]

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

[#4]

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

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[#6]

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.

[kaushiknsolanki · Accepted solution]

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

[#8]

Hi ,Solanki:

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

Best Regards.