Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Assigning text in a table

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.

1 Solution

Accepted Solutions
Mark_Little
Luminary
Luminary

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

View solution in original post

17 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

What is the output?

mightyqlikers
Creator III
Creator III

what is the logic for to get description.

please eloberate.

$@m.

Not applicable
Author

The output is the Description Column

Anonymous
Not applicable
Author

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?

Not applicable
Author

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

mightyqlikers
Creator III
Creator III

what is the logic for that.

$@M.

Not applicable
Author

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

Digvijay_Singh

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

Not applicable
Author

No I want it to appear per customer selection