topic Re: Assigning text in a table in QlikView

Assigning text in a table

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

From the table below, I have the Customer and Costs columns as dimensions. What I want to achieve is get a column called Description and assign the following descriptions as shown in the Description column. Please any help on how to figure these out?

Customer Costs Description

HighElectro € 1,924,11 Regular costs

HighElectro € 353,32 Rental costs

HighElectro € 79,33 Connection costs

HighElectro €354,00 Other costs

HighElectro €119,48 Other costs

Thanks.

Re: Assigning text in a table

MindaugasBacius — Mon, 20 Jun 2016 08:58:49 GMT

What is the output?

Re: Assigning text in a table

mightyqlikers — Mon, 20 Jun 2016 09:01:14 GMT

what is the logic for to get description.

please eloberate.

$@m.

Re: Assigning text in a table

Mon, 20 Jun 2016 09:01:19 GMT

The output is the Description Column

Re: Assigning text in a table

Anonymous — Mon, 20 Jun 2016 09:02:13 GMT

where does you description come from?

Regular Costs, Rental Costs

even with an inline table you Need a connect to existing datamodel

can you post your datamodel?

Re: Assigning text in a table

Mon, 20 Jun 2016 09:04:39 GMT

The description does not come from anywhere. That is what I am trying to achieve based on the Costs column.

Re: Assigning text in a table

mightyqlikers — Mon, 20 Jun 2016 09:06:30 GMT

what is the logic for that.

$@M.

Re: Assigning text in a table

Mon, 20 Jun 2016 09:08:46 GMT

I don't know that is why I am asking help

Re: Assigning text in a table

Digvijay_Singh — Mon, 20 Jun 2016 09:09:43 GMT

Do you want to manually assign Description, You can use input field but that will be cleared in next reload?

Re: Assigning text in a table

Mon, 20 Jun 2016 09:12:16 GMT

No I want it to appear per customer selection

Re: Assigning text in a table

Anonymous — Mon, 20 Jun 2016 09:16:32 GMT

Assuming there is some logic based on the costs column to define what the description should be you could apply that logic in your load script for example:

If(Costs= € 1,924,11,'Regular costs',etc) as description or you could create a mapping table if you have a few costs to apply a description to. It is difficult to suggest the best way without a more detailed outline of your requirements.

Kindest Regards

Brian

Re: Assigning text in a table

varshavig12 — Mon, 20 Jun 2016 09:18:07 GMT

Inline load

Re: Assigning text in a table

Mark_Little — Mon, 20 Jun 2016 09:19:55 GMT

Hi Simon,

What people would need to know is how each of he descriptions are defined. I.e. if cost is a certain amount then or if it is a certain customer type...

The Logic will be something like

IF( SUM(Costs) > 100, 'Connection costs',

IF(....

Mark

Re: Assigning text in a table

Anonymous — Mon, 20 Jun 2016 09:25:24 GMT

if you have nothing else than your 2 dimensions,

you may hardcode your desired column

if (Costs=1924.11, 'Regular Costs',

if (Costs=353.32, 'Rental Costs',

if (Costs='79.3','Connection Costs',

....

But you only get what you want. This is not a good solution!!

you need something different as e.g. a category to identify the different costs

Re: Assigning text in a table

MindaugasBacius — Mon, 20 Jun 2016 09:26:24 GMT

How do the cost appear? Is it from ledger?

Re: Assigning text in a table

Mon, 20 Jun 2016 09:53:43 GMT

Thank you all for your help. I will try to use your suggestions and adapt my needs

Re: Assigning text in a table

Mon, 20 Jun 2016 09:54:24 GMT

Thanks for the help I will try to use your suggestion as adapt my needs

Re: Assigning text in a table

Mon, 20 Jun 2016 09:55:12 GMT

Thanks Mark, I will try to use your suggestion and see how to achieve what I need