Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Summary Table

Hi

I have created two straight tables which show the results of two if statements. One has 3 results and the other has 2. I would like to create a separate summary table which has the check, so check 1 & 2, along with the number of results. Illustration below.

And is it possible to drill down from this, so get further information on the person with that name

Check 1

NameHeader 2
Tom1
Paul1
Bill1

Check 2

NameHeader 2
Jill1
Adele1

Summary

Check NumberHeader 2
Check 13
Check 22

Thanks for any help anyone can give

Iain

5 Replies

Re: Summary Table

Check1:

Load *,'Check 1' as [Check Number] Inline

[

  Name, Header 2

  Tom, 1

  Paul, 1

  Bill, 1

];

Check2:

Load *,'Check 2' as [Check Number] Inline

[

  Name, Header 2

  Jill, 1

  Adele, 1

];

Now create a Straight Table

Dimension

[Check Number]

Name

For 2nd Dimension, Tick Enable Conditional and write below in expression

IF(GetFieldSelections([Check Number])>0,1,0)

Expression
COUNT([Header 2])

Re: Summary Table

Perhaps a straight table without dimensions and the two expressions from your other straight tables. Disable the total mode for the expressions and enable the Horizontal option on the Presentation tab.


talk is cheap, supply exceeds demand
Not applicable

Re: Summary Table

Thanks for that, it worked. However the information I used was an example and I could have thousands of pieces of information that changes daily, is there a shortcut instead of typing that load in?

Thanks,

Iain

prb
New Contributor

Re: Summary Table

Hi Gysbert,

is there a way to create a straight table without dimensions? I have one with two expressions only and I think it needs at least one dimension.

Employee
Employee

Re: Summary Table

You can create a dimensionless Straight table Piotr, and add only expressions to it.

Community Browser