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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ester_pr
Partner - Creator
Partner - Creator

Matrix For Pivot Expressions

Hi all,
Is there a way to make group from expressions?
I mean, I have exp.1 exp.2 and exp.3,
I want to create a dimension if it is closed it will show the sum of exp 1 and exp 2., exp 3 will stand alone
If it will be open the title will be the sum and exp. 3 . the Sub title will be exp 1 and exp 2 and exp 3

Thanks,

Ester

5 Replies
Not applicable

can u elaborate with some sample file/data/picture ?

ester_pr
Partner - Creator
Partner - Creator
Author

exm.JPG

ester_pr
Partner - Creator
Partner - Creator
Author

With an option of pivot

Thanks,

Ester

Not applicable

i think u've in ur mind what u need....but sorry i dnt understand much from this

Probably u need something like cyclic expressions but there u can see one expression at a time.

Regards

ester_pr
Partner - Creator
Partner - Creator
Author

no, not that ,i need 2 expressions to see them apart , and in one sum if opening pivot

Thanks,

Ester