11 Replies Latest reply: Feb 17, 2015 7:43 AM by Andre Toerien RSS

    Hiding row data in table

    Andre Toerien

      Hi

       

      I want to display a table with information, but I want to exclude all information where field1  <> 0 and in field2 does not have a value of say 'A'. Best would be set analysis but i want the values to change as other selections are done, those two fields though have to be constant and not include any other rows of data

       

      The initial table already needs to only reflect data where field1 = 0 and field2 = 'A', even without selections being made

       

       

      Any help would be greatly appreciated

       

      Andre

        • Re: Hiding row data in table
          Gysbert Wassenaar

          Perhaps something like this:

          if(len(GetCurrentSelections()),count({$+<field1={0},field2={'A'}>}field3),count({$<field1={0},field2={'A'}>}field3))

            • Re: Hiding row data in table
              Andre Toerien

              This looks like something with dimensions and expressions

               

              What I am looking for is the following. I have the four columns below in a table. I want to hard code the table to only show me records where [ExpectedConsumption]={0.000} and [MeterType]={'K'}. Can this be done a table? you also need to take into account selection made on other fields not showing here. There are no sums or counts in question, this is just an add on to this other question with detailed information as in thread 151794

              Capture.PNG

                • Re: Hiding row data in table
                  renjith pl

                  may be somthing like this

                  assuming this is a straight table with UnitDescription as dimension and below can be expressions..

                  Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}ExpectedConsumption)
                  Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}MeterType)
                  Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}RegNo)

                    • Re: Hiding row data in table
                      Andre Toerien

                      Tried this, added extra field, how do I handle the expression which I would not want to use

                       

                      I added one extra column to show all 4 fields but one of them is not showing on the list of fields. Then no rows are showing probably because there is no Expressions, I can add one but then hide the column.

                       

                      Ideally I would want to show this in a table box not a straight table, but if there is no other way around it  the straight table would work, if I can add the hidden expression field

                        • Re: Hiding row data in table
                          Andre Toerien

                          So I have

                          Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}UnitDescription)

                          Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}ExpectedConsumption)

                          Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}MeterType)

                          Only({<[ExpectedConsumption]={0.000},  [MeterType]={'K'} >}RegNo)

                           

                          All with enable Conditional - this is where the aove expressions are loaded, also added suppress when value is null on all, for some reason sum nulls are showing so I hid it, I also added an expression, just added a 1  and I hide the field. That works ok now but for some reason the ExpectedConsumption Column is just now showing,

                  • Re: Hiding row data in table
                    SIYABONGA DLAMINI

                    andret

                     

                    Just did this in my qlikview, one possible way if I understand ur query correctly, is to go to your presentation tab in your chart, then tick conditional for the fields you want to display. for example you can put  field1 <> 0 and field2 <> 'A ', in both fields, this condition will work when you do your selection.

                     

                    I hope this resolves it.

                     

                    regards Dlamini

                    • Re: Hiding row data in table
                      Andre Toerien

                      Attached is some sample data