selected values

[sakamsureshbabu]

in my  exp i need selected sum like

sum(total)

but total value based on  "bill type = B "

how can i get

[sakamsureshbabu]

HI

my dimension  is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show

[MK_QSL]

Provide some sample data...

[its_anandrjs]

Then write

Sum( {< BRAND = {'Y'} >} AmountMetric)

For new question post new thread please

Regards

Anand

[sakamsureshbabu]

I need dimension row

how can i get

[Agis-Kalogiannis]

Create your pivot table and select your dimensions (ornament and brand for example)

Then you can drag the dimension column (brand)  in you pivot table and move it as a row on the top of the table (horizontal blue arrow).

Is this what you're trying to do?

[its_anandrjs]

If it is dimension

If( Match( BRAND,'Y'),BRAND) //And in properties use Suppress When Value is Null

or in load script you can filter that records

Load

If( Match( BRAND,'Y'),BRAND)  as [Y Brands]

From Location;

Provide and sample file

Regards

Anand

[Michael_Tarallo]

Hello Suresh - I noticed you have been posting QlikView questions NON-related to the QlikView Deployment Framework in the QDF section - can you please post your QlikView questions to:

New to QlikView

Thank you

Regards,

Mike Tarallo

Qlik

[Agis-Kalogiannis]

Could you please mark my answer correct or Helpful if it's working and ask any other questions by creating a new post?

thanks Suresh

Agis

[MK_QSL]

Request you to close the thread by selecting correct/helpful answer rather than asking another question on the same thread.. By closing the thread will help other users who are facing similar problems..

Thanks...

[its_anandrjs]

Hi,

Close the thread by selecting appropriate answer as correct or helpful for references for new question open new thread.

Regards

Anand