topic Re: Calculated dimension in QlikView

Calculated dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a calculated dimension and I want to create a list to select the output value shown in the calculated dimension column. How can link these two?

To shwo it with an example:

Client Evolution Sales

A Up 50

B Up 604

C Down 98

D Up 856

E Down 46

Up or Down is the calculated dimension. Now I want a list with Up and Down in order to filter the infomration shown in the table...

Re: Calculated dimension

lorenzoconforti — Thu, 19 Oct 2017 21:21:40 GMT

You can create a list and select <Expression> as field; you can then insert the expression used for your calculated dimension. The fields listed will be the same as your calculated dimension and you'll be able to filter using them

Re: Calculated dimension

Anil_Babu_Samineni — Fri, 20 Oct 2017 01:51:47 GMT

What if Evolution is your list box filter?

Re: Calculated dimension

lorenzoconforti — Fri, 20 Oct 2017 05:18:34 GMT

It would work

Try it. If it doesn't work maybe post your application; it would be easier to help you

Re: Calculated dimension

Anonymous — Fri, 20 Oct 2017 11:32:21 GMT

I've tried this, and the list box is filled up with the output, but when I select one of them, automatically all output is selected and the table is not filtered. I'll try to creat an example .qvw this weekend, although I'm afraid that what I want is to complicated.

Is there any easy way to create a list box with some options and then apply a programmed filter? It's all about a sales comparison (customers, articles) and I want to filter those who have increased, decresaed, new or lost sales. But it all depends on dimensions used etc. I've done anmd reached already a lot of my purposes, but the problem is, is that clicking the calculated dimension doesn't work. The .qvw is to big to attach...

Re: Calculated dimension

sunny_talwar — Fri, 20 Oct 2017 11:34:05 GMT

Would you be able to share a sample to look at this?