topic How to create region wise sales reports(dynamic) in QlikView

How to create region wise sales reports(dynamic)

Wed, 25 Nov 2020 16:16:04 GMT

Hi I Have scenario,

Want to create a straight table based on region(More of trellis)

Please find the attached doc for reference can any body help me on this.

Please do the needful

Regards

Thiru

Re: How to create region wise sales reports(dynamic)

PabloOrtiz — Fri, 20 May 2016 16:22:59 GMT

Hi, can you attache a example of straight table whit the expected information?.

Re: How to create region wise sales reports(dynamic)

johnw — Fri, 20 May 2016 22:13:53 GMT

It's brute force, but I'd honestly just make four straight tables, then use set analysis to restrict the dimension value that shows in each, like sum({<Currency={'USD'}>} Amount). Get one table that looks perfect, then just clone it and edit the expression. That's exactly what I did with a dashboard a month or two ago.

I'm curious if someone knows a more clever method, though.

Edit: And it's not dynamic. If you add new regions/currencies, you have to add new charts. I'm afraid I've not thought of a dynamic solution.

Re: How to create region wise sales reports(dynamic)

Mon, 23 May 2016 06:53:50 GMT

HiJohn,

I am also soing the same,But looking for dynamic.

Thiru

Re: How to create region wise sales reports(dynamic)

Mon, 23 May 2016 06:56:12 GMT

Please find the attached excel for understanding

Re: How to create region wise sales reports(dynamic)

Kushal_Chawda — Mon, 23 May 2016 07:01:40 GMT

Create the Inline for currencies

CurrencySelection:

LOAD * inline [

CurrencySelection

USD

GBP

SEK

NOK ];

Create the Listbox for this CurrencySelection field on front end. Select one currency.

Create the Variable vCurrency on front end to store the selection and pass it to set analysis. Just call field name in Variable like below

=CurrencySelection

Now create the straight Table

Add dimensions needed and add the below expression

=Sum({<Currency ={"$(=vCurrency )"}>}Amount)

Using this approach you will not need to create the 5 different Straight table. Only one table will be sufficient

Re: How to create region wise sales reports(dynamic)

Mon, 23 May 2016 07:07:51 GMT

Hi Kushal,

My Requirement is need to create 5 different tables

So need to create That,It's More of Trellis,Please find the attached Excel for reference.

Thiru