Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rikkeqlik
Contributor III
Contributor III

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
Partner - Master III
Partner - Master III

Please provide sample app with sample data and expected output.

rikkeqlik
Contributor III
Contributor III
Author

brunobertels
Master
Master

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
Contributor III
Contributor III
Author

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
Master
Master

Hi

may be

In contrôle panel of the dimension

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

Unchek the case "show others"