topic Re: How to write expression in table?urgent help please in QlikView https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695099#M1083178 <HTML><HEAD></HEAD><BODY><P>I have to show the table as in attached.</P><P></P><P>here class and state are under column Type</P></BODY></HTML> Tue, 17 Jun 2014 13:30:23 GMT 2014-06-17T13:30:23Z How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695098#M1083177 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a fields ID, Type, Days and I need to write expression which shows the count of ID where</P><P></P><P>days Less than 100 Days, days Less than 2 year, days greater than 100 Days </P><P></P><P>can anyone suggest me how can I calculate this.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 17 Jun 2014 13:28:03 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695098#M1083177 2014-06-17T13:28:03Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695099#M1083178 <HTML><HEAD></HEAD><BODY><P>I have to show the table as in attached.</P><P></P><P>here class and state are under column Type</P></BODY></HTML> Tue, 17 Jun 2014 13:30:23 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695099#M1083178 2014-06-17T13:30:23Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695100#M1083179 <HTML><HEAD></HEAD><BODY><P>I have below data in days sample data</P><P></P><P>199</P><P>1</P><P>31</P><P>23</P><P>21</P><P>1161</P><P>1147</P><P>1146</P><P>1133</P><P>1132</P><P>1131</P><P>1128</P><P>1118</P><P>1008</P><P>986</P><P>981</P><P>971</P><P>958</P><P>949</P><P>939</P><P>937</P><P>935</P><P>931</P><P>930</P><P>909</P><P>883</P><P>881</P><P>879</P><P>874</P><P>869</P><P>861</P><P>858</P><P>851</P><P>845</P><P>839</P><P>837</P><P>827</P><P>826</P><P>825</P><P>823</P><P>820</P><P>819</P><P>816</P><P>813</P><P>811</P><P>809</P><P>806</P><P>804</P><P>797</P><P>796</P><P>792</P><P>791</P><P>783</P><P>782</P><P>778</P><P>774</P><P>770</P><P>769</P><P>767</P><P>764</P><P>760</P><P>756</P><P>755</P><P>753</P><P>750</P><P>749</P><P>746</P><P>743</P><P>741</P><P>736</P><P>735</P><P>732</P><P>729</P><P>727</P><P>726</P><P>725</P><P>724</P><P>722</P><P>719</P><P>718</P><P>715</P><P>714</P><P>712</P><P>711</P><P>708</P><P>707</P><P>706</P><P>701</P><P>700</P><P>699</P><P>697</P><P>693</P><P>691</P><P>690</P><P>687</P><P>686</P><P>685</P><P>684</P><P>683</P><P>680</P><P>679</P><P>678</P><P>526</P><P>676</P><P>669</P><P>666</P><P>665</P><P>663</P><P>662</P><P>657</P><P>656</P><P>649</P><P>645</P><P>644</P><P>641</P><P>637</P><P>630</P><P>629</P><P>628</P><P>624</P><P>623</P><P>622</P><P>620</P><P>617</P><P>448</P><P>615</P><P>614</P><P>610</P><P>609</P><P>607</P><P>601</P><P>600</P><P>599</P><P>596</P><P>594</P><P>592</P><P>589</P><P>588</P><P>587</P><P>586</P><P>582</P><P>581</P><P>580</P><P>579</P><P>578</P><P>575</P><P>574</P><P>573</P><P>572</P><P>571</P><P>569</P><P>567</P><P>565</P><P>564</P><P>561</P><P>560</P><P>559</P><P>558</P><P>557</P><P>553</P><P>551</P><P>550</P><P>547</P><P>546</P><P>545</P><P>543</P><P>531</P><P>525</P><P>523</P><P>519</P><P>518</P><P>517</P><P>516</P><P>515</P><P>512</P><P>511</P><P>510</P><P>5</P><P>509</P><P>508</P><P>505</P><P>504</P><P>503</P><P>502</P><P>500</P><P>499</P><P>498</P><P>497</P><P>496</P><P>495</P><P>494</P><P>491</P><P>490</P><P>489</P><P>488</P><P>487</P><P>486</P><P>484</P><P>483</P><P>482</P><P>481</P><P>480</P><P>477</P><P>476</P><P>475</P><P>479</P><P>473</P><P>470</P><P>469</P><P>456</P><P>458</P><P>460</P><P>462</P><P>463</P><P>465</P><P>467</P><P>449</P><P>461</P><P>453</P><P>454</P><P>450</P><P>447</P><P>434</P><P>432</P><P>431</P><P>429</P><P>428</P><P>440</P><P>438</P><P>437</P><P>435</P><P>433</P><P>430</P><P>427</P><P>426</P><P>425</P><P>423</P><P>421</P><P>420</P><P>419</P><P>418</P><P>417</P><P>414</P><P>270</P><P>768</P><P>713</P><P>524</P><P>474</P><P>459</P><P>413</P><P>412</P><P>411</P><P>410</P><P>406</P><P>393</P><P>392</P><P>391</P><P>389</P><P>386</P><P>385</P><P>384</P><P>383</P><P>379</P><P>378</P><P>377</P><P>376</P><P>375</P><P>372</P><P>371</P><P>370</P><P>369</P><P>368</P><P>365</P></BODY></HTML> Tue, 17 Jun 2014 13:33:01 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695100#M1083179 2014-06-17T13:33:01Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695101#M1083180 <HTML><HEAD></HEAD><BODY><P>please can anyone help me!!</P></BODY></HTML> Tue, 17 Jun 2014 13:44:03 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695101#M1083180 2014-06-17T13:44:03Z Re: Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695102#M1083181 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In this case you may use a pivot table with an calculated dimension (button "Create Calculated Dimension").</P><P></P><P>It shall be something like:</P><P></P><P><SPAN style="font-family: terminal, monaco;">If(</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp; Days&gt;0 and Days&lt;100,</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp; '0 to 100 days',</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp; If(</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Days&gt;=100 and Days&lt;200,</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '100 to 200 days',</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #339966;"> //if( //other segments comes here</SPAN></SPAN></P><P><SPAN style="font-family: terminal, monaco; color: #339966;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp;&nbsp;&nbsp; ...</SPAN></P><P><SPAN style="color: #339966; font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //)</SPAN></P><P><SPAN style="font-family: terminal, monaco;">&nbsp;&nbsp;&nbsp; )</SPAN></P><P><SPAN style="font-family: terminal, monaco;">)</SPAN></P><P></P><P>Then the expression should be something like count(DISTINCT ID).</P><P></P><P>Regards</P></BODY></HTML> Tue, 17 Jun 2014 13:46:24 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695102#M1083181 fernandotoledo 2014-06-17T13:46:24Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695103#M1083182 <HTML><HEAD></HEAD><BODY><P>Hi Amelia,</P><P></P><P>Did you tried <A href="https://community.qlik.com/people/FERNANDOTOLEDO">FERNANDOTOLEDO</A>'s reply</P><P></P><P>It should work,else let me know</P><P></P><P>Regards</P><P>Jeba</P></BODY></HTML> Tue, 17 Jun 2014 14:04:08 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695103#M1083182 Anonymous 2014-06-17T14:04:08Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695104#M1083184 <HTML><HEAD></HEAD><BODY><P>If statement as Fernando mentioned should suffice. You could also try using class function. For more buckets you may want to try interval match....</P></BODY></HTML> Tue, 17 Jun 2014 14:09:11 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695104#M1083184 2014-06-17T14:09:11Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695105#M1083187 <HTML><HEAD></HEAD><BODY><P>i think interval match is the better choice for you</P><P>M_Groups:</P><P>&nbsp; LOAD * INLINE [</P><P>&nbsp; Group, Start, End, Order</P><P>&nbsp; &lt; 25, -10000, 24, 1</P><P>&nbsp; 25-44, 25, 44, 2</P><P>&nbsp; 45-54, 45, 54, 3</P><P>&nbsp; 55-64, 55, 64, 4</P><P>&nbsp; 65-80, 65, 79, 5</P><P>&nbsp; Other &gt; 80, 80, 9998, 6</P><P>&nbsp; N/A, 9999, 9999, 7</P><P>&nbsp; ];</P><P></P><P>then </P><P></P><TABLE><TBODY><TR><TD></TD><TD>IntervalAgeMatch:</TD></TR><TR><TD></TD><TD>INTERVALMATCH (Data) LOAD Start, End resident M_Groups;</TD></TR></TBODY></TABLE><P></P><P>and after you are able to use Group as a dimension without calculating anything in the chart </P></BODY></HTML> Tue, 17 Jun 2014 14:18:17 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695105#M1083187 2014-06-17T14:18:17Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695106#M1083189 <HTML><HEAD></HEAD><BODY><P>Thanks. How can I write the dimension condition as</P><P></P><P>I have to show the count of id when Type=Class</P><P></P><P>and count of id when Type= State</P><P></P><P>Please help</P></BODY></HTML> Tue, 17 Jun 2014 14:20:29 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695106#M1083189 2014-06-17T14:20:29Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695107#M1083190 <HTML><HEAD></HEAD><BODY><P>Count({&lt;Type={'Class','State'}&gt;}Distinct ID)</P></BODY></HTML> Tue, 17 Jun 2014 14:22:11 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695107#M1083190 venkatg6759 2014-06-17T14:22:11Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695108#M1083192 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Tue, 17 Jun 2014 14:28:42 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695108#M1083192 2014-06-17T14:28:42Z Re: How to write expression in table?urgent help please https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695109#M1083194 <HTML><HEAD></HEAD><BODY><P>If this answer is correct, please mark it so.</P><P></P><P>Also, why is everything such a hurry / high priority / urgent? I'd speak to your boss regarding unrealistic deadlines. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 17 Jun 2014 14:39:11 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-table-urgent-help-please/m-p/695109#M1083194 ThornOfCrowns 2014-06-17T14:39:11Z