topic Re: Text Format Property QlikView in QlikView

Text Format Property QlikView

Tue, 30 May 2017 13:46:59 GMT

Hi peoples,

I'm having an issue using the text format y pivot table that contains one dimension. The data is correctly related but I don't know why somethings records don't take the format.

The dimension i'm using is the customer name but my condition in the text format expression is with another field.

I just created an Test QV file to explaing more or less the issue.

Re: Text Format Property QlikView

sunny_talwar — Tue, 30 May 2017 13:52:02 GMT

Seems to be working with Customer 4 and Customer1 bolded?

Re: Text Format Property QlikView

Oleg_Troyansky — Tue, 30 May 2017 13:52:52 GMT

As far as I can see, the logic is working as expected - the two customers that are associated with Customer Type L1, are formatted as Bold, and the two other customers are not. Please explain what is not working?

cheers,

Oleg Troyansky

Upgrade your Qlik Skills with my book QlikView Your Business - An Expert Guide to QlikView and Qlik Sense..

Re: Text Format Property QlikView

CarlosAMonroy — Tue, 30 May 2017 13:53:33 GMT

Hi Julisy,

Based on your condition, the table is showing the format the way should be. What's the issue then?

=if(CustomerType = 'L1', '<B>')

Re: Text Format Property QlikView

Tue, 30 May 2017 13:55:55 GMT

Yes, in this simple example it work, just shared you this text file to you see the structure but the data that I'm reading from de Database, there are records that has the customerType = L1 but don't appear with bold format.

I don't know why happends this. if you can help me I would be very grateful

Re: Text Format Property QlikView

Tue, 30 May 2017 13:58:46 GMT

I would like to shared you my original Qv document but it use confidencial information of customer.

Re: Text Format Property QlikView

CarlosAMonroy — Tue, 30 May 2017 14:01:36 GMT

So then, you have to make sure it is really 'L1', could be an space in the cell or I do not know.

'L1 ' or ' L1 ', ' L1'

Make sure is 'L1'

Thanks,

Carlos M

Re: Text Format Property QlikView

sunny_talwar — Tue, 30 May 2017 14:03:07 GMT

See if this addresses your confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

Re: Text Format Property QlikView

antoniotiman — Tue, 30 May 2017 14:12:48 GMT

Hi,

May be

Customer:
LOAD * INLINE [
Customer, CustomerType, Total
Customer1, L1, 100
Customer2, L3, 200
Customer 3, L2, 400
Customer 4, L1, 300
Customer1, L2, 500
];

=if(WildMatch(Concat(DISTINCT CustomerType),'*L1*'), '<B>')

Regards,

Antonio

Re: Text Format Property QlikView

Tue, 30 May 2017 14:15:10 GMT

I just verified the record and it doesn't have space. I just tryied applying the Trim() funtion to delete blank space but is the same result.

Here is happening something weird because when i add the two dimensions, it work correctly but i don't want to display the customertype.

Re: Text Format Property QlikView

Tue, 30 May 2017 14:19:26 GMT

jajajajaja thanks Antonio, it was the solution.

=if(WildMatch(Concat(DISTINCT CustomerType),'*L1*'), '<B>')

Now it work for all records.

Re: Text Format Property QlikView

Tue, 30 May 2017 14:20:30 GMT

the communite for this foro don't display me the correct answer option. I will select as util

Re: Text Format Property QlikView

Anil_Babu_Samineni — Tue, 30 May 2017 14:25:09 GMT

Or,

=if(WildMatch(CustomerType, 'L1'), '<B>')

Re: Text Format Property QlikView

Fri, 02 Jun 2017 21:42:53 GMT

Hi, Antonio,

I'm having a issues with someone records; there are case who has L1 in customer type but this customer don't have sales for that month and QlikView is not formating in bold format.

are there someone way to indicate that don't considere if customer has sales or no?

Re: Text Format Property QlikView

antoniotiman — Fri, 02 Jun 2017 22:20:52 GMT

Try to uncheck 'Suppress zero values'

Re: Text Format Property QlikView

Mon, 05 Jun 2017 16:10:25 GMT

When I'am checking the data in the QlikView document, it is bold format, but when generate a macro to export to pdf, it appear in normal mode.