Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to take only some values from created dimentions table

Hi  Friends,

I have created a Dimentions table while loading tables.

Dimentions:

Commisions

Premiums;

Now I want to add only one of these dimentions into pivot table.

When add Dimentions its taking both Commisions and Premiums into the table Dimentions

Thanks

pavan

4 Replies
walterlh
Creator II
Creator II

Utiliza IF()

tresesco
MVP
MVP

Try calculated dimension. Expression like: =if(Dimension='Commisions', Dimension) , then in the same tab check 'Supress Values When Null'.

walterlh
Creator II
Creator II

Como se llama tu campo? donde guardas "Comisiones y Las primas"...

mohamed_ahid
Partner
Partner

i didn't get you . can you send us an exemple or may be an app?