Inline as a Dimention : which chart type should prefer

[sanketkhunte]

Hi Friends,

I have one requirement : to present KPIs against multiple dimentions those are not coming from database but they are valid DIM.

let say I have to present below chart :

-----------------------------------------------------------------------------------

Dimention                                KPI

-----------------------------------------------------------------------------------

Purchase                                   100000

------------------------------------------------------------------------

Sales                                         40000

----------------------------------------------------------------------

Discount                                        400

----------------------------------------------------------------------

in above table chart : 1.Purchase 2. Sales and 3. Discount are not coming from database so i have created inline for populating this values in Qlikview.

How we can present data same like above tabular format in qlikview when dim. are coming from inline.

your solutions really appriciate to us.

Thanks

Sanket

[nizamsha]

Like this

if(dimension='Purchase',ur Expression,

if(dimension='Sales',ur Sales

if(dimension='Discount',ur Discount)))

[manojkulkarni]

check..

Dimension =ValueList('Purchase', 'Sales','Discount')

Expression As

if(

ValueList('Purchase', 'Sales','Discount')='Purchase',100000,

if(

ValueList('Purchase', 'Sales','Discount')='Sales',40000,

if(

ValueList('Purchase', 'Sales','Discount')='Discount',400

)))

[#4]

If your INLINE dimensions are connected to the data model. You can use it anywhere.

Can you please attach a sample app.

Thanks,

Angad

[sanketkhunte]

Thank you for your input on this.

Here, I have requirement to display all dimentions at a time ; not anyone

Thanks

Sanket

[sanketkhunte]

Thank you for your input on this.

Here, I have requirement to display all dimentions at a time ; not anyone

Thanks

Sanket