topic Re: Straight Table Query in QlikView

Straight Table Query

Wed, 25 Nov 2020 16:16:04 GMT

HI All,

i have the data loaded in straight table:

tcategory	ttaskname	tus	tuk	tas

BAU	abc		a	a
Project	efg	WIP	WIP	WIP
Project	sdf		WIP	WIP
Project	ghj		Pipeline	Pipeline
Project	cfghy		WIP	WIP
Project	asdret		WIP	WIP
BAU	fgh	a	a	a
BAU	Client/Portfolio Pricing	Pipeline
BAU	Client/Portfolio Pricing		a

and my expected result is as below:

tcategory	ttaskname	tus	tuk	tas

BAU	abc		a	a
Project	efg	WIP	WIP	WIP
Project	sdf		WIP	WIP
Project	ghj		Pipeline	Pipeline
Project	cfghy		WIP	WIP
Project	asdret		WIP	WIP
BAU	fgh	a	a	a
BAU	Client/Portfolio Pricing	Pipeline	a

please advise

thanks

Sukhwant

Re: Straight Table Query

Anil_Babu_Samineni — Fri, 16 Sep 2016 16:58:14 GMT

Suppress null values from Presentation tab

I've taken dim - tcategory, ttaskname, tus

Expression - If(Len(tuk)>0,tuk)

If(Len(tas)>0,tas)

Then Supress the data, You will get exactly what you required. PFA for Ref.

Re: Straight Table Query

Oleg_Troyansky — Fri, 16 Sep 2016 17:01:11 GMT

If I understand your requirement correctly, you need to combine various values for the three last columns by Category and Task. In order to achieve that:

1. Use Category and Task as Dimensions

2. Use three Expressions with the following formula:

MaxString(tus)

MaxString(tuk)

MaxString(tas)

Re: Straight Table Query

Fri, 16 Sep 2016 17:01:15 GMT

Hi,

Please take a look at the attached qvw.

Is this what you need?

- Stan

Re: Straight Table Query

sunny_talwar — Fri, 16 Sep 2016 17:01:39 GMT

In a table box or straight table? If you use a straight table with tcategory and ttaskname as dimension and other three as expression, it might workout for you