Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Table Cal help???

Hi Folks ,

See below:

I'm using pivot table , from level1 to Level 5 name are my dimensions and Quantity and Price are expressions .

I'm simply calling Quantity  and Price fields as expression .

Problem here is I'm getting duplicates numbers or values see below :

And If I'm calling only Level 1 and Level 1 Name as dimension and Quantity as expression I'm getting only single value .

My requirement here is to show all levels with there respective names as in image but Quantity and Price figures should not repeat.

Any Suggestion???

Thanks,
AS

29 Replies

Re: Table Cal help???

Try with

Sum(price)

sum(qty)

as expression

let me know

sujeetsingh
Honored Contributor III

Re: Table Cal help???

Confused ...can you post a sample or come in more words.

amit_saini
Honored Contributor III

Re: Table Cal help???

Hi Sujeet,

Please see the attachments.

Here for number "1024936001"  in Quantity I'm getting duplicate values like 1700, 1700

Thanks,
AS

amit_saini
Honored Contributor III

Re: Table Cal help???

Also in my previous comment see the image , each number is having some relation on different level . See color combinations .

Thanks,

AS

amit_saini
Honored Contributor III

Re: Table Cal help???

sorry not working.

Thanks,
AS

amit_saini
Honored Contributor III

Re: Table Cal help???

Hi Sujeet

Not sure if we can do this with  Dimensinality() function. I tried but no results.

Thanks

AS

saumyashah90
Valued Contributor

Re: Table Cal help???

Hi Amit,

IT seems you have 1-N (one to many relation ship)  i.e for Level1 you have 2or more values for other levels.

You will  get two values if you take all levels as dimensions

amit_saini
Honored Contributor III

Re: Table Cal help???

Saumya,

Yes u are right I do have 1-N relations and that's why i m getting duplicates .

If I restrict this to only one level I'm getting perfect result but user want to see all levels with   and I'm struggling here.

Thanks,

AS

saumyashah90
Valued Contributor

Re: Table Cal help???

Option1) Use Pivot Chart showing only Level1 and quantity.Once user clicks on + sign he can check other levels(but this will show duplicates in the end result)

Options2) You may have to change the script using GroupBy function

Option3)Try using other levels in expressions instead of Dimensions(this might get you null values)

Community Browser