topic Re: Unique Month and Year in QlikView

Unique Month and Year

krishna20 — Fri, 13 Nov 2015 10:39:43 GMT

Hi Folks,

I'm having grocery products like vegetables, Fruits, Dairy Items......My Table structure is PROD_ID, PROD_NAME, YEAR, MONTHLY wise sales, TOTAL SALES.

For every table, structure is the same.I applied cross table to achieve monthly sales. All tables having MonthYear. How can i achieve the unique Month Year for all tables.

If i select a month or year it should filter data accordingly for all the products.

Please find the attached sample data as well as sample app.

Please someone guide me to achieve this logic.

Re: Unique Month and Year

Gysbert_Wassenaar — Fri, 13 Nov 2015 10:53:07 GMT

See attached example

Re: Unique Month and Year

sunny_talwar — Fri, 13 Nov 2015 11:18:59 GMT

Alternatively, you can also add this at the end of the script:

FinalTable:

NoConcatenate

LOAD Veget_ID as ID,

Category_ID,

Veg_Prod_Name as Prod_Name,

Vegetable_Sales as Sales,

Veget_MonthYear as MonthYear,

Veget_Value as Value

Resident Vegetables_Sales;

Concatenate (FinalTable)

LOAD Fruits_ID as ID,

Category_ID,

Fruit_Prod_Name as Prod_Name,

Fruit_Sales as Sales,

Fruits_MonthYear as MonthYear,

Fruit_Value as Value

Resident Fruit_Sales;

Concatenate (FinalTable)

LOAD Dairy_ID as ID,

Category_ID,

Dairy_Name as Prod_Name,

Dairy_Sales as Sales,

Dairy_MonthYear as MonthYear,

Dairy_Value as Value

Resident Dairy_Sales;

DROP Tables Vegetables_Sales, Fruit_Sales, Dairy_Sales;

Re: Unique Month and Year

krishna20 — Fri, 13 Nov 2015 11:23:29 GMT

Thank You Gysbert.

Absolute solution. what i'm looking for....

Re: Unique Month and Year

krishna20 — Fri, 13 Nov 2015 11:25:18 GMT

Thank You Sunny...

Re: Unique Month and Year

sunny_talwar — Fri, 13 Nov 2015 11:26:15 GMT

No problem my friend

Re: Unique Month and Year

krishna20 — Fri, 13 Nov 2015 12:34:07 GMT

Hi,

gwassenaar , sunindia

Why it's loading only distinct values?? Please let me know the concept of script. Totals are coming as correctly. Please find the attached Jpg.

Re: Unique Month and Year

sunny_talwar — Fri, 13 Nov 2015 12:44:56 GMT

List box object is showing unique values, that doesn't mean it is loading unique values. Create a table box with ProdName, YearMonth and Value and you will see all values are still intact.

Re: Unique Month and Year

krishna20 — Mon, 23 Nov 2015 13:58:32 GMT

Thank you Sunny for your explanation and sorry for late reply..