Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

colur coding

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

Tags (2)
7 Replies
soniasweety
Valued Contributor III

Re: colur coding

Hi franky_h79 Mapping is not working in real application

Frank_Hartmann
Honored Contributor II

Re: colur coding

Not clear to me what you want to do.

please explain your requirement. And share expected Output!

soniasweety
Valued Contributor III

Re: colur coding

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

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))))

soniasweety
Valued Contributor III

Re: colur coding

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.

Frank_Hartmann
Honored Contributor II

Re: colur coding

see attached.

hope this helps

Re: colur coding

Check attached