Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hschultz
Partner
Partner

1 Dimension from 2 Criteria

Hi guys

I hope you can assist me. I have an issue where we would like to use 1 Dimension with an Expression, but there is another dimension as a factor.

Please see the attached QVW to understand the scenario.

In the end we would like to have a Straight Table, with the calculations, but excluding the 2nd dimension needed to get the correct values. In this example specifically, I need Dimension = Customer and Expression = Rate x Time.

I have tried even using a pivor table, but that also gives me the wrong info.

So the 2 questions are:

1. Can i use a Straight Table with 1 Dim only when i need the other?

2. How do i change the totaling of my Rate x Time in the pivot table? (Not sure if aggr is the correct use here as it doesn't seem to be working)

If anyone can assist please. Thank you.

1 Solution

Accepted Solutions
Vegar
Partner
Partner

Skärmklipp.GIF

Try normalizing the rates table and creating a concatenated key consisting of Product and possision.

See my edit to your sample example

Message was edited by: Vegar Arntsen, Lie Added picture.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

7 Replies
Not applicable

ok let me make sure i understand you problem. so even if you just have 1 dimension you want to see ableton 2 times and so on right?? what version of qv are you using?

regards,

MT

hschultz
Partner
Partner
Author

No. It is exactly the oposite. I want to see Ableton only once. But my caculation needs to work out in the same way as if there were position included as a second dimension

Not applicable

ok so what should be you result then for ableton?? cause right now you sum everything up

Vegar
Partner
Partner

Skärmklipp.GIF

Try normalizing the rates table and creating a concatenated key consisting of Product and possision.

See my edit to your sample example

Message was edited by: Vegar Arntsen, Lie Added picture.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

hschultz
Partner
Partner
Author

That is definately the result i'm looking for...

So if I get this straight, what you have done is

create a Cross Table of rates, then created a new link on Product & Position for both tables?

It's actually so much simpler than i had expected...

Vegar
Partner
Partner

Precisely. Happy to help.

Make sure to exclude the [Product] and [Position] in the rates table to avoid synthetic keys.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
hschultz
Partner
Partner
Author

Yes thank you. I have actually added them, but just renamed to make sure there's no syn's