Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

akmalhalim_
New Contributor II

How to compare between these 2 dimensions for row 1 only?

is there any solution on this? as u can see from the picture, i need to change the color of 10 to any colour that i want. but ist ispossible to query the Test parameter ph(5-10) and 03:00AM 10 only? thank you

Capture.PNG

Tags (1)
10 Replies
eduardo_dimperi
Valued Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

If([TestParameter]='pH(5-10)' AND [03:00 AM]=10, YELLOW())

akmalhalim_
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

=IF(IF([Test Parameter] like 'pH (5-10)',

          IF([03:00AM]>=6,

              IF([03:00AM]<=10,GREEN(),BLUE()))),

       

     IF([Test Parameter] like 'TSC% (20%-50%)',

          IF([03:00AM]>=20,

              IF([03:00AM]<=50,GREEN(),BLUE()))))

Capture.PNG

can you help me on this? this query does not effect my table. i want to do it for all test parameter. kindly appreciate your answer before.

igoresz1
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

Muhammad, you use 'cross table' for presentation. So, the answer, IMHO, will be at the side 'operations with CrossTables'. Do you want to try to solve it yourself with only lightweight advices? Or already only want the 'final answer'?

akmalhalim_
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

yeahh. i want the final answer if u may. thanks

igoresz1
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

may be this way? it seems to be very traditional/classic for most of BI tools.

igoresz.JPG

igoresz1
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

the way to use kilograms of parameters from a traditional cross-table used as a source:

igoresz2.JPG

p.s.

igoresz3.JPG

crosstable‌ crosstables‌

akmalhalim_
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

thanks mr Игорь Степанов. but may i know this can happened in Qlik Sense?

akmalhalim_
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

if([Test Parameter] like 'pH (5-10)' AND [03:00AM]>=5 AND [03:00AM]<10,BLUE(),

if([Test Parameter] like 'TSC% (20%-50%)' AND [03:00AM]>=20 AND [03:00AM]<51,GREEN(),

    if([Test Parameter] like 'Viscosity (cp)' AND [03:00AM]>10 AND [03:00AM]<13,YELLOW(),

        if([Test Parameter] like 'Particle Size (<2.269µm)' AND [03:00AM]>1 AND [03:00AM]<3,BLACK(),

            if([Test Parameter] like 'Sieve Residue (45µm)' AND [03:00AM]>1 AND [03:00AM]<46,BROWN(),

                if([Test Parameter] like 'Sieve Residue (20µm)' AND [03:00AM]>1 AND [03:00AM]<21,BROWN()))))))

as u can see in this query, the 1st row in 03:00AM should be BLUE but it became white. actually this table, i want to display the data that in range, if out of range, it change other colour. but it seems like impossible. correct me if im wrong. thanks

Capture.PNG

igoresz1
New Contributor II

Re: How to compare between these 2 dimensions for row 1 only?

Muhammad,

I used soft that was currently under(in) my hand(comp), it was QV desktop. But it doesnt matter, it's just a Qlik family product. May be there are some manual differences, but not the model and pivot-table... I hope))

Regarding the 'painting')), it looks like you already have some results.

You can leave here the sample-file and we(forum users) can check it here later.

Regarding the model and instrument: I showed the 'cross-table model' as incremental source (my second attempt, see above both of them) and the usual pivot table as the instrument for presentation, where I just manually moved "Timeline"\"Periods" field to Header of a regular pivot table. I will check later the QS desktop later for this type of manual operations with regular pivot-tables... but probably it worked there too the same way.

BR, Igor)