topic Re: Dynamic Dimension on Charts using $Field in QlikView

Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 10:55:04 GMT

Dear All,

I have many dimensions in my report and there is space constraint on the design layout. So we had decided to show only 4 dimensions at any given time. I mean 4 pie charts with same expressions. And I am using the SYSTEM TABLE FIELD - $Field for displaying the list of dimensions. And below is my chart expression...

Chart Dimension Expression : =($(=$Field))

Chart Expression : COUNT({$} Resp_ID)

This works fine for the first chart. Now I wanted to simulate for the 2nd, 3rd & 4th charts. I mean I thought I could use SET IDENTIFIER ($_1) for the 2nd Chart and then ($_2) for the 3rd Chart...

However I can't use the SET IDENTIFIER in my Chart Dimension Expression : =($(=$Field)). Please can someone help me on this? Or please suggest a better appraoch if any...

Many thanks in advance.

Cheers - DV

Dynamic Dimension on Charts using $Field

kaushiknsolanki — Wed, 18 May 2011 11:14:19 GMT

Hi DV,

You can use "Container" for showing different pie charts at same position. This way you can save the space.

Regards,

Kaushik Solanki

Re: Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 11:22:13 GMT

Hi Kaushik,

Thanks for the quick response. We are not using Version 10 yet. We are still on QV9 with SR7. And its not just saving the space, it is more about comparing multiple dimensions across same facts. So I thought I can use the $Field for business users to select the specific dimensions and compare the results based on their needs.

I thought I can use something like this... ONLY({$_1} $(= [$Field])) - which doesn't work in my case. Or is there a function to identify the 1st, 2nd, 3rd....etc selection on specific field?

Many thanks again for your time.

Cheers - DV

Re: Dynamic Dimension on Charts using $Field

kaushiknsolanki — Wed, 18 May 2011 11:42:31 GMT

Hi,

I am uploading one document, pls have a look and tell me is this what u want

Regards

Kaushik Solanki

Re: Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 11:57:25 GMT

Kaushik - Thank you again. Yes, but I need more than this... explaining you in more detail based on your example.

If you paste this =($(=$Field)) expression in your chart dimension and then select one value from $Field list box, you would see the data in the chart expanded/breakdown for that dimension. This is what I have done so far... Now I want to copy the same chart 3 times and I wanted to show the breakdown for 3 more selections in $Field list box.

So lets assume I select Clients (as first selection) the 1st chart should show the data related to clients... and then I select Consulting and the 2nd chart should show the data related to consulting... same for the 3rd & 4th selections.

And if I dont select anything, then it should not show any charts.

Hope this makes sense.

Cheers - DV

Re: Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 11:59:16 GMT

All I am trying is to use the Dollar Sign Expansion with Set Identifiers. But I can't get the syntax right

Thanks - DV

Re: Dynamic Dimension on Charts using $Field

kaushiknsolanki — Wed, 18 May 2011 12:25:08 GMT

Hi,

It can be possible with the help of macros.

I need some input from your side.

Tell me onething how will you restrict user to show charts.

Meaning he may select all fields, so how u have decided to limit that

And do you want chart to disappear with selection cancelled.

It may take time to develop with macro, but yes its possible

Regards,

Kaushik Solanki

Re: Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 12:36:46 GMT

Hi Kaushik,

Its like you are reading my mind I am just referring the API guide to write VB Script.

Here are answers to your questions:

Question : Tell me onething how will you restrict user to show charts.

Meaning he may select all fields, so how u have decided to limit that

Answer : Let the users select all the fields however they will only see first 4 selections in the chart

Question : And do you want chart to disappear with selection cancelled.

Answer : We haven't decided on this bit, for now let's consider that charts will disappear.

Many thanks again for your time. Let me know if you can get this working.

Cheers - DV

Re: Dynamic Dimension on Charts using $Field

erichshiino — Wed, 18 May 2011 13:19:17 GMT

Hi, DV

That's good that you found another solution.

If you need to use that kind of expression again, the syntax is more like:

SUM ( $(=ONLY({$1}$Field))) to get the last selection on $Fields instead of $_1 which will give you the next selection (!!!!) - in the case you used the back button.

Regards,

Erich

Re: Dynamic Dimension on Charts using $Field

Wed, 18 May 2011 13:30:04 GMT

Hi DV,

By the time i tried to find the solution and work on the sample document to post here, Erich has suggested the solution which i had on my mind.

Have a look at the attched application.

Hope this helps you.

- Sridhar

Re: Dynamic Dimension on Charts using $Field

IAMDV — Wed, 18 May 2011 13:49:36 GMT

Erich - This is exactly what I needed!! Many thanks for your help. Although I had created subroutine in VB Script to get working. However, I prefer to use the Set Analysis solution instead of VB Script.

Sridhar - Thanks so much for taking time to provide demonstration. I had marked your post as Helpful

Cheers - DV

Re: Dynamic Dimension on Charts using $Field

Wed, 23 Jan 2013 15:24:22 GMT

Hi Kaushik,

Your Consulting Services QVW is exactly what I was looking for.

Thanks for the help!

Regards,

Amit