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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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