topic Inline as a Dimention : which chart type should prefer in QlikView

Inline as a Dimention : which chart type should prefer

sanketkhunte — Tue, 18 Feb 2014 09:51:33 GMT

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

Re: Inline as a Dimention : which chart type should prefer

nizamsha — Tue, 18 Feb 2014 09:58:31 GMT

Like this

if(dimension='Purchase',ur Expression,

if(dimension='Sales',ur Sales

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

Re: Inline as a Dimention : which chart type should prefer

manojkulkarni — Tue, 18 Feb 2014 10:00:20 GMT

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

)))

Re: Inline as a Dimention : which chart type should prefer

Tue, 18 Feb 2014 10:02:32 GMT

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

Can you please attach a sample app.

Thanks,

Angad

Re: Inline as a Dimention : which chart type should prefer

sanketkhunte — Tue, 18 Feb 2014 10:26:53 GMT

Thank you for your input on this.

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

Thanks

Sanket

Re: Inline as a Dimention : which chart type should prefer

sanketkhunte — Tue, 18 Feb 2014 10:27:13 GMT

Thank you for your input on this.

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

Thanks

Sanket