Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Dimension value in Expression tab

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

4 Replies
Highlighted
Specialist II
Specialist II

Re: Dimension value in Expression tab

Hi

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

Thanks,

Varun

Highlighted
Not applicable

Re: Dimension value in Expression tab

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.

Highlighted
Specialist II
Specialist II

Re: Dimension value in Expression tab

Is it possible to share sample data?

Highlighted
Specialist II
Specialist II

Re: Dimension value in Expression tab

HI,

Please try the attached