topic Re: Using dimensions from datamodel and synthetic dimension in Valuelist function in QlikView

Using dimensions from datamodel and synthetic dimension in Valuelist function

neelamsaroha157 — Thu, 06 Oct 2016 16:19:53 GMT

Hi everyone,

I have a format of a report that I want to achieve with the maximum optimization as the calculations are too complex.

Currently I tried using :

Dim:

=Pick(Match(Dim, 'Quarter Year', 'YTD','Synthetic Dim 1', 'Synthetic Dim 2', 'Synthetic Dim 3'),

[Quarter Year],'YTD','Synthetic Dim 1', 'Synthetic Dim 2', 'Synthetic Dim 3' ) --where Dim is an field from inline for these Dimension names.

Then In expression I am using Pick and Match.

I am able to achieve the result till Rolling quarter but when I am adding another dimension to my Calculated Dimension, its not working.

I hope I am able to explain myself...

Any help would be appreciated

Thanks in advance.

Re: Using dimensions from datamodel and synthetic dimension in Valuelist function

sunny_talwar — Thu, 06 Oct 2016 16:27:46 GMT

Very difficult to say what might not be working without looking at a sample. Would you be able to provide one?

Re: Using dimensions from datamodel and synthetic dimension in Valuelist function

neelamsaroha157 — Thu, 06 Oct 2016 18:23:10 GMT

Hey Sunny,

Thanks for your reply.

I have tried to create the sample data and highlighted the calculation in yellow on 1st sheet and sheet 2 & 3 has data.

Thanks

Re: Using dimensions from datamodel and synthetic dimension in Valuelist function

sunny_talwar — Fri, 07 Oct 2016 12:59:51 GMT

Neelam it might be helpful if you can share the qvw you have thus far. I am not sure what all expressions you have and how you reach them. I might be able to figure them out, but it can take me hours.

Best,

Sunny

Re: Using dimensions from datamodel and synthetic dimension in Valuelist function

neelamsaroha157 — Fri, 07 Oct 2016 15:07:19 GMT

Hey Sunny,

Sorry to make it hard for you..

I have prepared the sample qv as well and everything seems to work fine in that.

But not able to figure out whats wrong in real scenario and I know you cannot help in that.

In real scenario I am able to get everything but either [Month Year] or [Quarter Year], not both..

Thanks