Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
neelamsaroha157
Specialist II
Specialist II

Using dimensions from datamodel and synthetic dimension in Valuelist function

Hi everyone,

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

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.

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

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

neelamsaroha157
Specialist II
Specialist II
Author

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

sunny_talwar

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

neelamsaroha157
Specialist II
Specialist II
Author

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