Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different expressions in a pivot table expression??

Hello,

I Would like te create a table like this:

KPICurrent yearLast yearGrow%
Total sales amount€ 120.000€ 100.000020%
Toy sales amount€40.000€ 50.000-5%
Number of customers5.0004.00025%
Number of sales/products per customer2425-4%

Therefore I created a pivot table.

As dimenzion I defined

= valuelist
( 'Total sales amount','Toy sales amount', 'number of customers', 'number of sales per customer').

That works.

But how do I define the expressions?

I think I can best define two expressions Current year an Last year each containing 4 expressions.  But how do this?

Could you please help?

Thanks

0 Replies