Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rikkeqlik
New Contributor II

Need some help with a table

I the following table I would like to show only the latest %, but still have the sales values for 2017 Q2 og Q3. How can I do that?

    

Notes%Sales 2016Budget 2017Sales 2016 Q4Sales 2017 Q1Sales 2017 Q2Sales 2017 Q3
2017 Q2,Q30,017512 581 4207 113 0003 236 8063 058 7552 906 4522 837 834
2016+2017 Q10,01412 581 4202 850 0003 236 8063 058 7552 906 4522 837 834

There are several people who's gonna use the table - filtering options are necessary

5 Replies
shraddha_g
Honored Contributor III

Re: Need some help with a table

Please provide sample app with sample data and expected output.

rikkeqlik
New Contributor II

Re: Need some help with a table

brunobertels
Valued Contributor II

Re: Need some help with a table

Hi

May be like this with a calculated dimension on the Contract dimension like this

=if(% = '0.0175',Contract)

so the sorting table will be :

rikkeqlik
New Contributor II

Re: Need some help with a table

Thanks, but I don't think this would help.

I'm interested in the newest % (in this case 2017 Q3). There are several Contract Numbers with several different %'s. I've created a new field which combines year and quartal and changed the expression : =IF([Budget.Period]='201703',Contract)

This is the result:

As there are sales in other budget periods, they come up "blank"

brunobertels
Valued Contributor II

Re: Need some help with a table

Hi

may be

In contrôle panel of the dimension

=IF([Budget.Period]='201703',Contract)

Unchek the case "show others"

Community Browser