topic Re: To create straight table dynamically in QlikView

To create straight table dynamically

Anonymous — Fri, 10 May 2013 10:44:34 GMT

Hi All,

I would like to create the straight table dynamically based on the input given.

I have 3 fields Currency, Category & Amount.

My straigh table will have Category as Dim & Amount as Expr.

Now my input would be Currency.

If I didnt select any of the currency then a straight table should be created for each currency value and if I select a particular currency then the straight table should create for that currency alone.

Whether it is possible to do??

Please share your thoughts.

Thanks,

Leni

Re: To create straight table dynamically

advait_thakur — Fri, 10 May 2013 11:02:22 GMT

Hi Leni,

Yes it is possible. To understand more I would like understand your actual requirement.

This is what I have achieved..

whenever a user click on the dimension Category and Amount the report will get display. To achieve the same I created the list boxes : one for dimensions (category in your case) and one for facts (amount in your case).

Through conditionally display in dimension and expression of chart you can display your currency by using substring function in qlikview.

Examply : substringcount(concat(factno, '|'), 1)

Thanks

Advait

Re: To create straight table dynamically

Anonymous — Fri, 10 May 2013 11:31:12 GMT

Actually I need to create the chart as in the attachment.

It looks something like Trellis chart & as trellis chart is not possible in straight table so I thought of generating the straight table for each of the currency as in the screenshot attached.

And I would like to know how to achieve this.

Thanks