topic Re: Can I change dimension dynamically in QlikView

Can I change dimension dynamically

Mon, 09 Feb 2015 12:24:28 GMT

Hi Expert,

I am facing some issue.

My requirment is that in Bar chart/graph I have got two expression i.e.

1. Sales Amount

2. Projeceted Sales Amount

For Sales I want to use Dimension column as Sales_Date,

and for Projected Sales I want to use Dimension Column as Projected_Sales_Date.

So, I want to change the dimension dynamically.

i.e While dimension selection instead to selecting column directly I will write if condition and accordingly the expression should

work out.

Is it possible?. I am in worst condition. It will be great if any solution I get quickly.

Advance Thanks

Re: Can I change dimension dynamically

Anonymous — Mon, 09 Feb 2015 12:39:38 GMT

Hello,

Create inline table with sales and projected as field values.

Use this table's values as a list box and provide conditions for the same in dimension and expression. Always keep one selected value

That's it.

HTH

Re: Can I change dimension dynamically

Mon, 09 Feb 2015 14:00:24 GMT

Hi Ravi,

I think you are not clear with my requirment. However can u send me th sample QVW file. So that I can check whether it meet my requirement or not ?

Advance Thanks

Re: Can I change dimension dynamically

Anonymous — Mon, 09 Feb 2015 14:30:54 GMT

In a situation where each view has its own dimension and its own expression, I'd recommend using two separate charts showing conditionally. Or maybe create a cycle group contacting both dimensions, use this group as a chart dimension, and the expression will be conditional of the current cycle filed.

Re: Can I change dimension dynamically

Tue, 10 Feb 2015 13:20:17 GMT

Hi Michael,

Can you give the sample qvw file please

Advance Thanks

Re: Can I change dimension dynamically

Anonymous — Wed, 11 Feb 2015 18:10:51 GMT

See attached.

Notice the cyclic group in the document properties - groups. It is used as the chart dimension. There are two different solutions in the two charts on the expressions level, use whatever you prefer.