topic colur coding in QlikView

colur coding

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

Hi andrey.krylov,

the requirement has changed

1. i want to show colur coding

2.... i added each text box with distinct - its alrdy done in attached file

3. i want same kind of 4 tables with the values showing in text object count. (not listbox)

like same we have done here in listbox the same way i want in stright table

listbox count

Re: colur coding

soniasweety — Mon, 05 Nov 2018 14:07:56 GMT

Hi franky_h79 Mapping is not working in real application

Re: colur coding

Frank_Hartmann — Mon, 05 Nov 2018 14:14:39 GMT

Not clear to me what you want to do.

please explain your requirement. And share expected Output!

Re: colur coding

soniasweety — Mon, 05 Nov 2018 14:20:52 GMT

whatever the attached qvw is working fine. but in the table it is showing two colours only

now i want to show 3 colours

1.red color should show the yotta , blue colur should show CDR and Yellow should show matching in both Yotta and CDR

2. Now the text boxes showing distinct count i want the stright tables for each text object count that related data

Re: colur coding

sunny_talwar — Mon, 05 Nov 2018 14:31:52 GMT

Try this

=If(Match([Deal ID],
$(=Chr(39) & Concat({<[Deal ID]=p({<Source= {'Yotta'}>})-p({<Source={'CDR'}>}) >}DISTINCT [Deal ID], Chr(39) &','&Chr(39)) & Chr(39))), RGB(255, 0, 0),
If(Match([Deal ID],
$(=Chr(39) & Concat({<[Deal ID]=p({<Source= {'CDR'}>})-p({<Source={'Yotta'}>}) >}DISTINCT [Deal ID], Chr(39) &','&Chr(39)) & Chr(39))), RGB(133, 145, 250),
If(Match([Deal ID],
$(=Chr(39) & Concat({<[Deal ID]=p({<Source= {'Yotta'}>})*p({<Source={'CDR'}>}) >}DISTINCT [Deal ID], Chr(39) &','&Chr(39)) & Chr(39))), RGB(255, 255, 128))))

Re: colur coding

soniasweety — Mon, 05 Nov 2018 14:36:39 GMT

the same way can we have 4 stright tables ? which we have done for listbox count

user click on text object red one-- that table should show with the values showing in that text object

if user clik on yellow it should show one table with the number of rows which showed in text object

like for 4 text objects i want to show hide 4 tables.

Re: colur coding

Frank_Hartmann — Mon, 05 Nov 2018 14:45:27 GMT

see attached.

hope this helps

Re: colur coding

sunny_talwar — Mon, 05 Nov 2018 14:47:02 GMT

Check attached