topic Re: Dimension value in Expression tab in QlikView

Dimension value in Expression tab

polisetti — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have 3 dimensions coming from Database. I want to show them in a table(two columns in dimensions and third column in expression).Currently, i have added the third dimension in dimension and in expression tab too. And thIn i have hidden dimension in presentation tab.

Is there any string function which i can add directly in expression so that i can remove hidden dimension?

I tried using firstsortedvalue and maxstring function, but those are only displaying top record for that level. But i have multiple records for same level. How can I achieve this ???

Regards,

Polisetti

Re: Dimension value in Expression tab

techvarun — Tue, 01 Aug 2017 06:58:11 GMT

Add three dimensions and one dummy expression (May be number 1) and hide the expression.

Thanks,

Varun

Re: Dimension value in Expression tab

Tue, 01 Aug 2017 07:09:35 GMT

Hi Varun,

We want to create the view in pivot table so that it can be seen either in pivot up or pivot down. But pivot table doesn't have option to hide dimension or expression.

Is there any function for this? All my dimensions are strings.

Re: Dimension value in Expression tab

techvarun — Tue, 01 Aug 2017 07:13:05 GMT

Is it possible to share sample data?

Re: Dimension value in Expression tab

techvarun — Tue, 01 Aug 2017 07:44:28 GMT

HI,

Please try the attached